Search results

I have searched the forums and I know that you can backup data in Access to Excel or another database. What I was wondering was if there was some way to backup your data to a backup file that you could import into another copy of the database on another computer (not on network). What are the...

Thanks Bob. I knew there'd be a simple answer. My brain is fried...it's been a long week!

This probably has a simple answer and I've looked through the forum to no avail but...... does anyone have a snippet of code that checks for the presence of a file? Thanks in advance.

Problem solved. Not sure what it was but running the repair and compact utility took care of it!

Another update. Code that is used in the database to backup the main data table to another database gives the same error. Hmmm.. I wonder if I'm on to something here.

One other thing to note. A select query pulling the same data works fine. Apparently the problem lies in the table creation?

I built my wife a database to use for her work that has worked fine for a good while now. Just yesterday, one of the make table queries began to act peculiar. Suddenly, whenever you try to run it it gives the following error: "The Microsoft Jet database engine has stopped the process because...

It appears that it is the second name that is coming up as invalid domain and any names following are simply ignored. Help please!

OK. I figured out what was going on with that but now the last name in the list of addressees is coming up as domain invalid. There are no commas or anything at the end so what gives?

I am trying to send out an eMail and attachment through Notes and when I used this code the first few times it worked. Now it keeps indicating that there isn't a session running when there is. I even checked to see if it was getting a value for UserName and MailDBName and it is. When I try the...

OK. I've looked around and the only suggested idea close to this didn't even remotely work. What I want to do is take the string of a month, (i.e. Jan or January) and convert it to a day (any day) in the month so I can calculate days in the month. I know how to calculate days in the month but...

Great! Thanks pbaldy!

I have a form and within that form a subform. The subform is a listing of payment history and in the footer is a hidden sum. That sum is passed to the main form and works fine as long as there is a record for that case number. However, if there is no record with that case number it shows #Error...

Thanks for the upgrade info. Two more questions: 1) Is the upgrade buggy enough that I should wait for some of the patches to be applied at the product leve? 2) What are these 'ribbons' you guys are referring to?

I've got Access 2000 and was wondering what I needed to upgrade to Access 2007. By this I mean, front page of manual, ID code, etc. And is it something I have to present at purchase or something that Microsoft validates online. Does anyone know?

Never mind! I figured it out!

Does anyone know how to reference the field name through VBA code? For example the table the recordset (rstOrders) is based on has a field named Customer. How do I reference that in VBA?

I have a form (data entry setting-yes) with several tab control-grouped forms. All the forms/underlying tables are linked by a field called ID. When I enter data in the main form, related records are only created in the tables for the subforms if data is actually typed into them as well. How do...

Can someone tell me the VBA code for testing whether a query recordset is empty or not?

Never mind. Finally figured it out and had to do with how the variable was defined if you can believe that! Thanks for your help RG!