Search results

I have set up a parameter query with multiple criterias. I have also set it up so the query will accept a null response from the user. I have done this by using the following string in the criteria section: [rma?] Or Like [rma?] Is null This works fine except how do I apply this theory to a...

Hi- I have a script that I got from the internet to send pdf emails. Everything here works fine. However, I now have a need to send multiple emails automatically. Could some help me put a loop into this code so I can send emails to everyone in the RMA table using the RMA report. Each report...

I have a table set up named PO2. I have a query named UPDATEPOFULLYREC. I would like to get an event written that would go to the first record in the PO2, open up the query (query has criteria set to a form currently and I know will need to change to the table) and run the query based on the...

I would like to create a query that compares 3 different inventory counts of our warehouse. I have created 3 separate tables and have put the serial numbers counted in each table. I would like to have 3 columns, each representing one tables data. The like serial numbers would line up across each...

Hi - I am trying to write a query that will give me all of the entries from one table and then add the lines from another table that have the same part number. The problem is that I cannot get the first table to show all line items even though I have a join that states to do this. Also, I know...

I am using the following module in my Access database: Public Function SendTextFile(strpath, strTableName, strRecipient, strSubject) Dim myOlApp As Object, myItem As Object, myAttachments As Object Dim MyPath As String, MyName As String 'First, export the text file using a saved Export...

I have a report that I export to excel. When I open up the excel file, the column properties are different than they were in access. For example, the date field in access is not a date field when transferred to excel. Is there something that I need to add to access to retain the properties...

I have written a DB in 97 and converted to 2002. I then secured my DB in 2002. This is a multi user environment. My problem is that I have two different forms that has data disappear in them approximately once a day. Both forms have main forms with subforms based on the same table...