Search results for query: *

How can I be sure that a string is a valid time of day and NOT a date. Help!

I've been using access for reports for a couple of years. Now, for the first time, I have to create a form. It is for simple add edit view using only one table. Before I start with all the controls and logic, I would like to know if there is some control or method that would allow the user to...

Thanks a million. view,menubar,reset did the trick. that clutter was really annoying. Thanks for you help!

Thanks for the reply! I couldn't close it without saving it either. I tried compact and repair and the application quit Access completely. I took a backup copy of the database and started fresh and it seems to run ok. Still, if anyone knows what’s going on I'd love to hear Thanks again!

VBA opens a report in design view,makes the needed changes then closes and saves.Well, it used to do that. Now I get an error message saying it cant close the report. After stopping the application, I saw that the report was indeed open. When I tried to close it nothing happens. It won't close...

A while ago some kind programmer showed me that you can drag a macro onto the menu bar and it will become a shortcut. One click and macro starts. The above-mentioned kind programmer has now confessed that he has no idea how to remove the shortcuts. I have a bar cluttered with shortcuts-even...

Sorry! I meant that there was NO import error table.

Hi Thanks. There was import error table. Heres a bit of the xls in question.

Problem: Importing a spreadsheet (get external data..) If "First Row contains column headings" is NOT checked the import works fine If "First Row contains column headings" IS checked I get the collumn headings and an empty table. Any ideas?

I'd like to compact my database at a specific time every night without having to do it manually from the menu. VBA has 'docmd.RunCommand acCmdCompactDatabase' which looks promising but you can’t compact the db that is running the code and I can't find where to specify a different db. Help!

I'd like to compact my database at a specific time every night without having to do it manually from the menu. VBA has docmd.RunCommand acCmdCompactDatabase which looks promising but you can’t compact to db that is running the code and I can't find where to specify a different db. Help!

Im looking for a good resource to learn about Access Report Events. I can't seem to find anything in books or online. Any suggestions?

I have a report 'Report A' which contains a subreport, 'subreport A'. I would like to use vba to alter Report A to use Subreport B instead of Subreport A. I'm getting all kinds of errors. Is it possible to do this? If so, what is the syntax? Thanks!

Access Crashed. message was Access needs to close now. it madea backup of the database then closed. when I try to open the backup I get this message Microsoft Jet Database caonnot find the object 'MySysDb' when I open the original database all the access objects have the new changes - as they...

Thanks MP9! I spent half a day trying to figure that out! it took 1 min to do it your way! thanks again

I need to change the heading of a report. Current version doesn't support openargs. I can set the tag property of the report with the docmd.openreport . I can't seem to change the heading. How can I get the Data from the tag to the heading? Is there any way to update the heading directly?

DoCmd.TransferDatabase acExport, "?????", _ "P:\anytownUSA\max.mdb", _ acTable, "Tablename", "P:\anytownUSA\fred.xls" Thanks . It doesn't accept any value I put in place of the ?????. thats where I'm supposed to specify MSexcel. the message i get is : 022507: The ????? type isn't an installed...

Looking for a way to export an access table to a spreadsheet using VBA. I can export it from the Menu le,export,..datbase type..) but the vba doesn't recognize the database type "microsoft excel" How do you tell vba that you want a spreadsheet thanks for any help

We’re trying to transfer Excel spreadsheets into an access 2002 database using VBA in access (transferspreadsheet). The transfer is ignoring the last row and last column of the spreadsheet. If the spreadsheet has 12 columns and 1000 rows the table will have 11 columns and 998 rows (one row is...

Thanks. I tried out your code and it works. This will give us a temporary band aid to keep the app going. If anyone has any idea about why this is happening I'd love to hear it . I have to know. Who knows what else is being affected by the same issue. Please. anyone??