Sponsored Links

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

Page 56 of 820

Threads in Forum : comp.databases.ms-access

Forum Tools

Rating Thread / Thread Starter	Last Post	Replies	Views
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	285
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	57
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	119
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	50
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	59
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	46
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	89
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	38
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	67
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	57
"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	51
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	44
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	87
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	50
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	18
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	65
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	88
navigation buttons I have standard navigation buttons at the bottom of a form. I would like to scroll through the records when I hold down the Next button. How do I... zufie	04-06-2009 11:51 AM zufie	0	40
navigation buttons I have standard navigation buttons at the bottom of a form. I would like to scroll through the records when I hold down the Next button. How do I... zufie	04-06-2009 11:51 AM zufie	0	74
Sad, Sad Microsoft Help How sad is it that if I want to get help on, say, the DateAdd function's parameters, I can type in Google "Access dateadd," get a list of sites... Neil	04-05-2009 10:56 PM Don Leverton	8	78
Conditional format in a sub form Dear reader, In a data sheet you have the possibility to work with a conditional format. In VBA code the following code is available for format... Simon	04-05-2009 08:13 PM lyle fairfield	9	31
Making Word the top window I have an Access (2007) database that produces an MS Word document populated with Access data. I open a Word template in the background, plug in the... evenlater	04-05-2009 02:56 PM evenlater	2	59
Adding Microsoft Office Excel Chart TO Access - The operation on theOLE object failed I am using Access 2007 on Vista. I added an unbound object frame to my form. When the box pops up I then selected create new also Microsoft... troy23	04-05-2009 10:47 AM Jens Schilling	1	71
Need Help - No Index On Linked Table I'm still on a newbie on these fronts, so be gentle. However, here is my situation. I have a fully working login form that refers to a users... Jim	04-04-2009 04:33 PM lyle fairfield	1	60
How to work with conditional format in a sub form Dear reader, In a data sheet you have the possibility to work with a conditional format. In VBA code the following code is available for format... Simon	04-04-2009 09:46 AM Builder	2	58
Re: XSD: Order irrelevant but choice required Hi Stephan, You are kinda working this the hardway. An xsd file is an xml file type for datasets used by the .Net system. In visual Studio.Net you... Rich P	04-03-2009 02:31 PM Rich P	0	28
Data is coming in different language Hi I am facing a problem with one access file. According to my knowledge it is encrypted with visual basic. Please help me to decrypt the file. I am... kapil	04-03-2009 11:24 AM Salad	1	53
How Can I Write a SQL Server Function that Returns a Memo Data Typein Access? I have a SQL Server function which returns the data type VARCHAR(max). When I use the function in a view and link to the view through ODBC, it... existential.philosophy@gmail.com	04-03-2009 11:09 AM MGFoster	3	51
Setting Language for non-Unicode programs programmatically I am trying to programmatically (vba) set set the "Language for non- Unicode programs", which can be found in Control Panel> Regional and Language... john@kosmosbusiness.com	04-02-2009 01:56 PM john@kosmosbusiness.com	5	45
Data disappears on Form and Subform Hi, I don't understand. The MAIN form header information is populated in the header of the MAIN form via a separate data entry form. However,... zufie	04-02-2009 12:28 PM banem2@gmail.com	3	51
Hiding a report while printing ACC 2003 ( 1 2 ) I'm trying to "hide" a report while printing. I need to open the report in preview mode as so to count the pages (if multiple so I can set the... brian.flannery@ci.verona.wi.us	04-02-2009 12:28 AM Terry Kreft	17	114
One Record Table I am using Access 2007 and I just can't figure out how to create a one record table. Could someone help me out? Thank you. JackonLI	04-01-2009 09:51 PM JackonLI	6	80
Disappearing Forms Yesterday I became so frustrated with Access 2007 that I converted the database I'm designing into 2002 -03 and began to work. I was modifying one... Tomahawk Lady	04-01-2009 02:33 PM banem2@gmail.com	1	68
#Num! displayed in a control ( in a textbox of a subform) I see #Num! displayed in a control ( in a textbox of a subform). What can I do to avoid this error? Do I need to add =IIf(=0,0, to the beginning of... zufie	04-01-2009 02:22 PM banem2@gmail.com	2	32
Graph is not printing in MS-Access 2007 Report Hi all I hav designed a databas in Access 2003. My Company is upgraded it by Access 2007. In the database there is a report, containing a graph that... Naushad	04-01-2009 02:13 PM banem2@gmail.com	1	57
Access 2007 Templates I have recently started downloading Access 2007 templates and modifying for my own use. Almost every change results in a request for backup. Access... Barry	04-01-2009 02:07 PM banem2@gmail.com	1	74
Rotate Text or label I am trying to create a form with about 100 text boxes or labels on it. I can programmatically set the ControlSource or Caption, set the Top and... Phil Stanton	04-01-2009 12:00 PM Phil Stanton	6	224
me.hDC Can anyone tell me what Me.hDC is. I presume this is a property only available in Access versions after AK2. Is there an equivalent for... Phil Stanton	04-01-2009 11:59 AM Phil Stanton	2	84
year search hi all ! i need a user to select a year from a list eg . 2007,2008,2009 when searching in a form that will run a query . however the date format in... brino	04-01-2009 02:17 AM Larry Linson	3	57
trying to make since out of a database I just received a mess. They admit it and are willing to do whatever it takes to fix. they have 4 tables and they entered the data in the tables,... sparks	04-01-2009 12:24 AM Builder	2	53
Problem w/ editing text near Tab character I am well aware that you cannot simply type a tab character into a text field because of the focus event. This post has nothing to do with that. I... occorled@gmail.com	03-31-2009 11:58 AM occorled@gmail.com	1	73
Re: trying to make since out of a database sparks wrote: Change the autoid columns in tables 1-4 to type Long Integer, and populate them with the autoid values from your new tblDemographics.... Builder	03-31-2009 11:26 AM sparks	2	41
display form on desktop Hi, I'm using Access 2003. On startup of my application I show a form. This form however is displayed on the layout of Access (menubars,... susan	03-31-2009 06:58 AM Allen Browne	1	56
Access 2007 ... Looks like it can use VBA? possibly Office 8.0 references? (MSO97.dll) "David W. Fenton" <XXXusenet (AT) dfenton (DOT) com.invalid> wrote Golly...is it that long ago....wow...just wow........ I mean, load up access... Don L	03-31-2009 01:19 AM Don L	8	62

Page 56 of 820

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