Recent content by B&R

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...

Thanks You are right! Thanks for taking a look at my problem. A second opinion is always a good idea. Again Thanks, B&R

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...

Maybe a silly thought but why don't you create a distribution list in outlook for the script to use. This way you can easily update the distribution list when someone leaves or needs to be added. It is so simple that anyone could do it even when you are out of town. You would also probably...

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...

Wayne - Sorry for the delay but I wanted to thank you for all your help! You suggestion was the answer to the problem. Again, thanks for taking your time to review my issue. Thanks, Rhonda

Wayne - Great suggestion, I will wait to try until you have completed your review of the database. I have limited time to access the system so I would like to make all changes at one time. Please look at the indexes, structure of tables and record locking. I just want to make sure they all...

Wayne - Sorry for the delay, holiday travels. This is in Access 2002, please let me know if you have any problems opening this copy. Thanks, Rhonda

Wayne - I have attached another copy with a couple of additional orders added to the RA order and RA order details tables. I understand how the DB could be confusing since I had to take out all the forms that direct you through. I will try to let you know to expect. First, go to form (SHIP...

Wayne - Since I sent the database, I have changed a couple of things grasping at straws. I put an autonumber primary key on the Equipment and Archive tables since they had no unique key and no primary. Just thought it might be best to have one and I removed the index off of the prodid field...

Wayne - Have not heard back from you so I was wondering if you found anything in the database I sent. I have some additional info. I have the following tables in my database that I did not send. They are: MSysAccessObjects1 MSysACEs 1 MSysObjects 1 MSys Queries 1 MSysRelationships 1 I don't...