Viewing 15 posts - 226 through 240 (of 273 total)
Is this a database that has been in use for some time? And was it originally upsized from Access to SQL Server? Finally, is this a .mdb format...
March 30, 2012 at 9:16 am
Under the circumstances, I think your best bet is to create the runtime as J. Livingston suggested - the tools to do that are readily available. Are you dealing...
March 8, 2012 at 4:27 am
You are sort between a rock and a hard place with 2003. The Lebans code is quite different from the export process that was introduced in 2007 and is...
March 6, 2012 at 11:49 am
... Wendell, you mentioned about adp not being supported by MS going forward, is the format they are supporting a normal access front end with linked tables? ...
Well, I didn't...
February 21, 2012 at 7:30 am
I think ProofOfLife has pretty much covered the issue of triggers, and I agree with what he has said. Triggers are difficult to test and debug so I generally...
February 20, 2012 at 6:45 am
You are very welcome - you have a daunting task ahead of you for sure. As a general comment, the tools in Access offer a great way of displaying...
February 14, 2012 at 7:21 am
kschwid (2/13/2012)
February 13, 2012 at 5:02 pm
INSERT INTO DATABASE_LOGIN_FILE ( , [TIME], [DATE], [DATABASE], COMPUTER, NOTES )
SELECT Environ("USERNAME") AS , Time() AS [TIME], Date() AS [DATE], "Refresh HD-Stat" AS [DATABASE], Environ("COMPUTERNAME") AS COMPUTER, "LOGIN" AS NOTES;That...
February 13, 2012 at 12:24 pm
Unfortunately there is no such function in Access. Two possible approaches you might consider:
1) open a recordset on your data and perform a rank calculation on each record using...
February 13, 2012 at 10:09 am
I would expect they used the linked approach to the SQL Server tables using ODBC. If you look at the tables in the Navigation Pane, you should see a...
February 13, 2012 at 9:42 am
This turns out to be a complicated subject. The first question is whether he is using the old .mdb format for his database, or whether he is using the...
February 4, 2012 at 11:02 am
Well, it looks like you have the latest Office service pack. Unfortunately I'm not able to duplicate your problem when using Memo fields - as long as I don't...
February 2, 2012 at 4:51 pm
One question I should have asked is whether you have Service Pack 2 of Office 2007 installed? There were some fixes to the import and export routines in that...
February 2, 2012 at 3:59 pm
By DoCmd I presume you are using the DoCmd.TransferSpeadsheet method. If you are importing the Excel file into a new table, Access does indeed check a few rows to...
February 2, 2012 at 5:18 am
What version of Excel are you exporting to? If you are choosing the .xls format it will certainly do that. However if you export to the .xlsx format...
February 1, 2012 at 3:18 pm
Viewing 15 posts - 226 through 240 (of 273 total)