Search results

Hi, wanting to know if anyone has come across any code that stops the vba from running if an 'output to' function is null. I've found some code using the DCount function but I'm struggling to adapt this to multiple excel outputs, any help much appreciated. I'm sending 5 excel files via E mail...

Hi, Not used loop function before and I'm struggling to understand how to set it up on my code.All works but does scroll to next record and repeats the code. Any help much appreciated.;) Dim db As Database Set db = CurrentDb Dim recRework As DAO.Recordset Set recRework =...

Hi, needing some help with a idea I have for my database but not sure how to . I have VBA to send multiple reports to a group of people depending on a toggle button selection. what I'm wanting to do is have it loop through the e mail process until all 5 toggle buttons have been selected and the...

Hi , Trying to send out some reminder E mails using some dates that I've set up in text boxes but can't get it to work. I've started out simple to get it working as I'm not familar with VBA If Me![Planned Finish] <= [2days] And Me![Final Reminder] Is Null Then MsgBox "YES", vbOKOnly...

Hi, Wander if any one has come across this before. I'm exporting a query that has currency values in with no decimal places but when it's viewed in excel it has 2 decimal places! I've changed the properties in the query to none, anyone know how to stop this from happening? I'm using 2003.

Hi, moving my database from 2003 to 2010 and I'm wanting to use custom tool bars that I created in 2003 to run searches Doing this I hide the ribbon, including the 'File' tab is this possible?

Hi, I have a search button on my form that filters the form via a macro and querie allowing you to fill in all combo boxes with your search criteria. I'm wanting to start the search from the form but it makes all the buttons in active when set. Is there a simple bit of code to make sure that my...

Hi , Looking to match to date fields within a query by using the month and year only, is it possible and how. Thanks and I'm using Access 2003

Hi all, Been hunting a round looking for some code that will output my access report to excel but more inportantly add a unique field from the report to the name of the file. example would be [FileName] & [ReferenceNo].xls Any help much apprciated. By the way working in access 2003 :D

Hi, I want to add a number to my results within a query depending on the month and how many results. For example I have 10 results in my query 3 from January, 5 from March and the rest from April. The 3 from January would be 1,2,3. The five in March would be 1,2,3,4,5 and so on. Is it possible...

I wander if anyone can help I'm wanting to send 2 reports to the same address but when you use the docmd. option you can only select one report at a time or is there a way round it? I'm using 2003 Thanks

Hi, I'm using 2003 and want to update a table of results that fall between 0~0.5, 0.5~1.0 and so on. Example If the result is 0.7 then I want to over write this with 1.0 and repeat this all the way down the column. Any ideas on the best way of doing this?

Hi, I'm using access 2003 and want to update my table with a time but first I need to calculate a total time from the results within the table. The table consists of OK, NG, and rework numbers and I need to calculate how long the job took by adding the results together and then multiply it by...

Hi I'm wandering if it's possible to get access to round numbers to the nearest 1/2 hour i.e. 0.5, 1.5 or 2.0 depending on the result. Any help much appreciated. Oh by the way I'm using 2003.

Hi, I'm using 2003 and I have a report that currently has 3 images appearing depending if you tick a box on a form or not. What I'm looking to do is have it appear depending on the result of the querie for example. I have 3 images titled A, B and OB. If A is in the querie A appears, B in the...

Hi everyone, I'm trying to send an attachments out to an E mail address thats selected by the person using the database selecting a customer on a dropdown cbo. What I was thinking, if I hyperlink the address on the form I could attach this to the mail, is this possible and if so how? Thanks...

I have a database that I need to modify but is passwrod protected through a workgroup file WRKGADM.EXE. Is there anyway to overcome this or add myself as an administrator? owner of the dtaabase is nolonger with us. databse is in access 97. Thanks

Been using a mailing program for some time to send out 2 documents using a mailing list in Access 2003 but for some reason, beyond me it has thrown up an error, any help much appricated. Private Sub Command12_Click() Do Dim objOutlook As Outlook.Application, objMailItem As MailItem Set...

currently using a2003 and I have vba updating a text box with a paragraph of text after a check box has been updated. What I don't want it to do is update the text box if text already exsist but put a message box saying delte text before update, here is my code. Me![Investigation Results] =...

Hi has anyone ever used VBA to enter text into a text box with sections of the text in different colours and return to the next line? for example. On the enter date we went to look at a problem. When we arrived it was enter time. The problem was related to enter part description. I'm...