Search:

I have a database that copies a table before a delete query runs. What I would like to do is be able to reload using an append query to repopulate the table that was deleted. The problem that I am...

Easy Fix. My Windows NT profile changed so the specifed path was invalid.

I have a set of reports that I am trying to export in snapshot format through VBA. This has worked fine for the last few months (I haven't changed anything) but now I am getting this error:
The...

I'm not much of a SQL programmer so this might be very simple.
I have a query that I need to show all the records except for the records that are in a second query.

For Example:
Query1 has...

I don't know what was wrong but now it is working. Thanks for the code. I did not know that function existed.

It is now giving me the "Object variable or with block variable not set" error.

I am not sure how to modify the drop downs, but the data seems to be coming from the lists at the right.

Try this. In the reports NoData event add this code:

Private Sub Report_NoData(Cancel As Integer)
docmd.openreport "YourOtherReport"




Then in the on open event of your "no data" report ...

I have a query that grabs all the records that have the current date in the date field.
What I would like to do is when a form is opened, a message box would open for each record in the query. With...

That worked great thank you!

I have a macro in a document called print.doc that opens a text document then saves it as output1.doc. The 1st document then closes but output1.doc remains open. If the user thens opens print.doc...

Thanks that worked great!

I have a table with an embedded picture in one field and an embedded .wav file in another. In a form I am trying to make the .wav file play when someone clicks a button. I know that you can...

That works great. Thanks.

I am using this code to insert a row between values if they are different.

Sub insertLine()
Dim cell
For Each cell In Range("BOB")
cell.Select
If Selection.Offset(-1, 0) <> "" Then
If cell <>...