Recent content by DoniFromMars

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