Search results

All I know is that what I've read over time, and my conclusion is that ADP files are not the way to go... Microsoft doesn't recommend their use either. Because of that, I don't make any ADP projects any more.

One suggestion is to not use ADP files. Rather, you can use MDB files and link to the SQL Server tables.

You can change your query from the default "select" query to a "make table" query. But you can simply base the second query directly on the first query. When you create the second query, you should see the dialog box where you can choose from a list of tables to base your query on - you should...

Accessing SQL Server data (presumably over a network connection) can be faster - especially if you are using queries to pare down the amount of data that is returned to your front-end application, and especially if you have concurrent users accessing the same underlying data. If you are...

That sounds simpler... I like it!

http://dev.mysql.com/doc/refman/5.0/en/time-zone-support.html I'd imagine that the above link will get you started - my guess is that you'd want to create a stored procedure (or whatever they're called in the mysql world) that returns the server's time. Then you can execute it to get the...

First, why do you have a field for age? Since that information is a calculation (current date minus birth date), you probably shouldn't be storing it. Rather, just calculate it whenever you need it. Here's a way of calculating it (this next line could be put into an unbound textbox on a form)...

You don't mention which version of Access you're using, but there's a pretty well-known bug with some versions (2000 and 97 at least, if I recall correctly) where using the Sendkeys command actually messes up the NUM LOCK key - turns it off. So if you're already using SendKeys elsewhere in your...

Try this: 1) Export the data as a text file, but delete everything except the first couple of records, and then save the extremely-truncated version with a new name. 2) Import this truncated version into Access, and see what happens. 3) If you still get the same error, then the problem is not...

So the text file will always have one line, with two and only two items?

I'd use the FileSystemObject: http://www.google.com/search?q=vba+append+files+filesystemobject

http://www.google.com/search?q=vba+copy+files+filesystemobject

Aren't you trying to find zero-length files? I'd think that you would need to check each file individually to do that... so your code would iterate through your file names, and you'd use the FileLen function to retrieve the file size of each file. Then your code would take whatever action that...

Dim lngLength As Long lngLength = FileLen("path and file name here") That should get you started...

What he said. :)

If you're trying to compact when you close, why not just tell Access to always compact when the database closes, rather than using your own code?

This works for me (Access 2003) - put this sub in a code module, and then in the Click event of your button on your form, just call the sub: Public Sub CompactDB() CommandBars("Menu Bar"). _ Controls("Tools"). _ Controls("Database utilities"). _ Controls("Compact and repair...

http://support.microsoft.com/kb/286153/

One alternate solution is to just ignore the error that you're seeing by using error-handling code in your sub or function. If you need assistance with this, just post your code, along with the error number that you're getting when a table already has a primary key.

Have a module-level string variable declared (e.g., Private strSelectedMemoText as String at the top of your Form's code module). In the LostFocus event (aka OnLostFocus in the Properties page of the control) of your memo field's textbox, put in this code: strSelectedMemoText =...