Sponsored Links

comp.databases.ms-access comp.databases.ms-access

Page 64 of 828

Threads in Forum : comp.databases.ms-access

Forum Tools

Rating Thread / Thread Starter	Last Post	Replies	Views
SharePoint Services ( 1 2 ) "David W. Fenton" <XXXusenet (AT) dfenton (DOT) com.invalid> wrote: I think the biggest reasons is the lack of referential integrity. That just... Don Leverton	04-18-2009 02:35 PM Tony Toews [MVP]	17	151
Don't want to update table Hi! I'm trying to create a form that allows the user to print a report based on an identifier that they enter. I created a form with a text box tied... Dave Moore	04-17-2009 01:55 PM Salad	6	55
Question: How can you generate a table via code? Hello fellow Access 2003 users, is there a way to provide a date (for example, 1/2/09) and then via code, create the following... nospam@nospam.nospam	04-17-2009 08:54 AM nospam@nospam.nospam	4	58
creating a report from a pivot table hello, i am trying to create a sales report with month column headers... i can get the data to look right by viewing the datasheet as a pivot... bipin	04-16-2009 05:00 PM Phil Stanton	4	138
Ranking by group I adopted a ranking approach which I found here (http:// allenbrowne.com/ranking.html) However, I am doing rankings by product and by working week.... Astley Le Jasper	04-16-2009 01:06 PM Salad	7	96
how do you check a string before replace I have a ton of strings I am parsing out and the only problem I have is knowing whats a date and whats a special chr in a text field. ##/##/## is a... sparks	04-16-2009 08:41 AM sparks	4	66
DB crashes and packing Hi We have some some systems, which save a lot of detailed/temporary data to an access table (some ~10 tables in a file), and 3-4 tables are heavily... jodleren	04-16-2009 02:13 AM jodleren	2	84
Is It Possible To Set The Secondary Y Axis Of A Chart With Code? I'm using information that I found in KB Article Q158938 to set the Y axis of charts with code based on stored values. The code I'm... Wayne	04-15-2009 05:37 PM Wayne	0	90
Prob with code in declarations section of form module ... ( 1 2 3 ) Am trying to use the following in declarations section of form module. Of course, it won't compile. What's the best way to set my constants inside... MLH	04-15-2009 05:08 PM Tony Toews [MVP]	26	139
Reference Problems Under Windows 7 On Apr 12, 9:38*am, "David W. Fenton" <XXXuse... (AT) dfenton (DOT) com.invalid> wrote: Don't know how you reached that conclusion David, but you... Wayne	04-15-2009 05:07 PM Tony Toews [MVP]	7	49
Using Image HyperlinkAddress to open a file with the location in atext box Hi, I'm having some trouble using images and their hyperlinks to open files. Any help would be really appreciated. I'm using Access 2003. I have... franc sutherland	04-15-2009 04:55 PM franc sutherland	7	41
Same Water Mark on all Reports Is there any way to have the same Water Mark on all reports? One solution may be to put the same background on each report, but, I would like to... squeezebot	04-15-2009 02:36 AM squeezebot	2	52
Text messaging I haven't done text messaging on my cell phone. I'll see things on TV like "Send a text message to the show. Enter #12345 from your cell phone..."... Salad	04-15-2009 12:29 AM Tom van Stiphout	3	78
using variable as default value in field Hi, In advance: I'm using the Dutch version of Access 2003 so I'm not sure I'm using all the proper discriptions. Anyway... I have a variable which... susan	04-14-2009 03:49 PM MGFoster	2	86
Convert System.mda (2.0) to System.mdw (2003) Hi All, I'm upgrading from Access 2.0 to Access 2003. I'm unable to convert the workgroup security file System.mda (Access 2.0) to System.mdw... Mourad	04-14-2009 12:17 PM Mourad	0	157
Upgrading from Office 2000 to 2007 Hello I have Microsoft Office 2000 Developer Edition. I mainly work with Access 2000 to create Access runtime solutions for distribution to many... G Gerard	04-14-2009 10:04 AM Tim Mills-Groninger	7	114
ADO transactions Hi, I use Access 2003 VBA. I cannot find the documentation relating to transactions in ADO. Is it identical to those in DAO? If not, where can we... Marcel Nihon	04-14-2009 07:38 AM lyle fairfield	1	93
Create a Data Entry Form From a Query Hi, I have been trying to Create a Data Entry Form From a Query as I need to feed values into two (2) respective tables. Is this possible? Any... zufie	04-13-2009 02:26 PM rkc	1	56
Access Project with SQL Backend write conflicts This is kind of hard to explain, but here goes... I've got an Access 2007 project front end with SQL 2005 backend. I've got a table that contains... prime80	04-13-2009 10:51 AM J Warner	2	88
Records are not saved after Paste 6:05 PM 3/20/2009 Records are not saved after Paste Senario: Microsoft Access 2003, Windows XP SP3 Copying data from an Excel... squeezebot	04-12-2009 01:29 AM squeezebot	7	99
Menu Bars Show/Hide Windows XP SP3 / Access 2003 SP2 Using the API (this is my function referring to the API) ShowWindow Application.hWndAccessApp,... squeezebot	04-12-2009 01:29 AM squeezebot	2	228
Query Columns to Row Output Not sure if I'm just missing something relatively simple. Have a table as below which has it's primary key as ProvID, Location ID ProvID ... veaux@aol.com	04-10-2009 09:09 PM MGFoster	6	62
Help on help Using A2003, if I select Microsoft Access Help from the Help menu from the database window and type "Methods", I get a list of methods. However, when... Salad	04-10-2009 02:37 PM Salad	6	78
Access 2007 Say it ain't so ... No "Expression Builder" in modules? Hi, Just getting my feet wet with Access 2007 (Trial version) this weekend. I downloaded the Contacts Database, and noticed the "Map it" button,... Don Leverton	04-10-2009 02:33 PM Larry Linson	9	49
Build an IN clause from SELECT records I want to build a string from results of a SQL SELECT statement. This string would be used for an IN clause in a subsequent SQL query. How do I... troy_lee@comcast.net	04-10-2009 11:06 AM MGFoster	6	53
display my queries on a form Hi, I want to automatticly display all thr names of the queris in my db in a listbox on a form. Is this possible? Thanks, Susan susan	04-10-2009 10:41 AM MGFoster	2	63
How do I check what group a user belongs to (A2003)? There is code in the SECFAQ but it only works if the user is a member of the Admins group. That will not work for me. I need to check what group... PW	04-09-2009 06:21 PM PW	2	81
Is it advantageous to use .NET Framework DLL's in Access? ( 1 2 3 ) Hi Everyone, David wrote (echoing Lyle too) The case I gave was of a disconnected worker. SQL Server Express is certainly a suitable container for... CDMAPoster@FortuneJames.com	04-09-2009 06:00 PM lyle fairfield	27	146
which 'Set' statement is the fastest Which will return the result the fastest?? if any. Set MyRec = MyDB.OpenRecordset(strSQL, dbOpenDynaset) Set MyRec = MyDB.OpenRecordset(strSQL,... bobh	04-09-2009 03:28 PM MGFoster	1	75
Re: SSRS 2005 - two questions about parameters Well, here is how you would retrieve a value from the gridview (in C#) protected void GridView1_SelectedIndexChanged1(object sender,... Rich P	04-09-2009 03:10 PM Rich P	1	44
Executing a pass through query in VBA Hi People, I am trying to execute a pass through query using the following code. sql = "EXEC DeleteOutPatientACP '" & rs!Fields(0) &... Nick 'The Database Guy'	04-09-2009 12:32 PM MGFoster	1	290
Cursor start position Is there any way to force the cursor to always start on the left hand side of the cell when the cell is clicked. This cell has an input mask for... troy_lee@comcast.net	04-09-2009 09:57 AM Terry Kreft	1	75
How To Determine Access Version And Service Pack Number I'd like to be able to determine the Access version and service pack number when a database is opened and flag to the user if they don't have the... Wayne	04-08-2009 10:10 PM Wayne	3	59
restrict data entry until fields are complete I have a subform with 26 fields and it has 2 requirements. Date and type until these 2 values are entered I do not want them to enter any partial... sparks	04-08-2009 06:22 PM Bob Quintal	7	43
A2003: This database is in an unexpected state; Microsoft Office can't open it I get this when I try to open the MDB with any user that is not the Admin. Any ideas? -paulw PW	04-08-2009 04:49 PM PW	0	48
Form and Scroll Bar Is there a property to use to ensure that a Main form opens with its Right Scroll Bar all the way to the Top of the form? My Main form opens just... zufie	04-08-2009 10:47 AM zufie	3	130
Ensuring uniform control width on forms and reports This utility ensures you have uniform control width on forms and reports. This example shows the Unit Number as found in many forms and reports... Tony Toews [MVP]	04-08-2009 10:45 AM KC-Mass	5	56
Forms not displaying correctly in Access 2003 I have a database that I built in Access 2007 in the Access 2002-2003 format. I just added a new subform and now one of the forms doesn't display at... musicloverlch	04-08-2009 04:45 AM musicloverlch	2	67
CDO email procedure produces error I have a procedure in Access that sends an email via CDO using a gmail account. 90% of the time it works, but some of my users are getting this error... evenlater	04-08-2009 02:02 AM John Mishefske	1	50
Blank Form I don't get it! I created a form from a query. However, when I look at Form View the form is blank. That is, none of the fields show. I ensured... zufie	04-07-2009 08:59 PM banem2@gmail.com	2	93
Is "autoexec" the only way to resolve a /cmd code? Hi All, I've been trying to use the /cmd commandline argument and the command, uh, command. :) It's not working, and it's dawning on me that every... jonceramic	04-07-2009 05:55 PM jonceramic	1	42
Vista 32 vs 64 I have a customer with a new Vista 64 computer. Our A2000 mde runs fine on Vista 32 but on V64 he gets a error that... Karl	04-07-2009 05:19 PM Karl	0	76
sql syntax error Hi im getting a syntax error on the following and cant figure out where i've gone wrong, any suggestions? SQL = "insert into... paul	04-07-2009 03:47 PM MGFoster	5	64
"Date()" doesn't update when application stays open Hi all, Question: How do I refresh the "date()" when my application is open more than 24 hours? ----------------------------- I've got an... jonceramic	04-07-2009 03:39 PM Tony Toews [MVP]	6	55
Converting Field Values into Strings Hi, I am attempting to convert field values into consecutive strings but I am getting a Data Type mismatch error (Runtime 3464.) I am trying to get... Henry Stockbridge	04-07-2009 01:33 PM Henry Stockbridge	4	48
Vista Vs XP deployment problem David, I changed all ADOX to late binding and it works nicely. Thanks, John john@kosmosbusiness.com	04-07-2009 09:58 AM john@kosmosbusiness.com	6	94
Excessive CPU utliization I think my largish Access system (300mb backend, complex frontend), deployed on Citrix, is somehow causing clients to grab CPU time and not release... Builder	04-07-2009 09:54 AM Roger	4	55
problem with different methods of invoking stored procedures throughADO Hi all I may have missed something obvious, but the two methods of assigining parameters when calling an SQL stored procedure produce... Accessed	04-07-2009 05:54 AM lyle fairfield	1	25
How to retrieve a user's password, along with the group and user name (in code)? Hey, I want to populate a listbox with the names of all users, what groups they belong to and what their passwords are. I have tried this but there... PW	04-06-2009 02:33 PM PW	4	67
Possible to get users and their groups (Access Security)? Hi, Am using Access 2003. Is there any way I can populate a listbox with the names of all the users and the groups they are associated with? I can... PW	04-06-2009 12:49 PM PW	7	91

Page 64 of 828

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off