Search results for query: *

Need each department's data to start on new page. Setting Department Header Force New Page to Before Section leaves first page without data. Setting Department Footer Force New Page to After Section forces Report Footer to new page (undesirable, especially when the report is limited to one...

The following code marks claim numbers in a report if they are duplicates of the previous claim number printed or if there is a gap in sequence between the current and previous claim numbers. Michael Red got me to the point that this works, except that when the list goes on to a new column or...

Since I cannot write code myself, I copied the following code from an old post and got it working in my database, but I would like it to copy the name already entered in the cboTo combo box so that the user doesn't have to retype it in the frmFaxListAddContact entry form. Private Sub...

I know I've seen the answer to this before, but I can't for the life of me figure out how to search the forum for it. I have a text field which for some unfathomable reason has a number of entries with "*" as the first character. I want to run a query to delete the "*", but...

Many months ago when I started working here, there was an annoying splash screen that came up every time I opened an Office Program. I got that to stop in Excel, but now when I am forced to use Word I get a Microsoft Visual Basic run-time automation error. How can I find out what code it is...

As they do in bank statements when there is a missing check or two, I would like to mark records where there is a gap in the sequence. I would also like to mark where there is a duplication (because it is probably an error that needs to be looked into.) This is not a numeric field, but text...

I set up a query (in Excel) to import data from Access to Excel, and then moved the database to a different directory. Is there a way to update the query with the new path, or do I have to do a whole new query?