Search results

I have a database that tracks equipment being reserved, checked out, check in and cancelled……… When I am entering a date for when someone will bring back a piece of equipment. The system checks to see if it’s a weekend or holiday and goes back to that field so a correct date can be entered if...

I have an excel document that when it's opened it needs to loop through each record and if the date in column (G) is < 90 days ahead, an email needs to be sent to someone. Here is the code for the loop. All of a sudden it's telling me that an Run-time error '424': "Object Required" and goes...

I reserve, check-out and check-in equipment that is loaned out to our employees (projectors, microphones, laptops, etc.) When putting in a date the equipment needs to be picked up, I run it through the following code to ensure we don't reserve for weekends or holidays. Unfortunately, when...

I am sending an email from a button, and it runs a word merge and then attaches that word document and two others two an email. All that works fine, but in the body of the email the carriage return is not working. I've tried "vbCrLf", "Chr(13)" and "Chr(10)". but none of them are working in...

I send pdf'd versions of reports out automatically all the time. You don't have to have Adobe or any other PDF program to do it either. DoCmd.OutputTo acOutputReport, ReportName, acFormatPDF, "Location Where Report Will Be Saved\NameYouWanttoGiveReport"& "" & ".pdf" Call EmailReport I...

I have a table with a Key Field which is Autonumber, - Field Name: SeriesID - Field Size: Long Integer - New Values: Increment - Indexed: Yes (No Duplicates) - Text Align: General I am appending new records into this table and it is duplicating the SeriesID. last record was: SeriesID...

Thanks very much!!!!:d

I have a letter that has different text fields in it. I know how to format date fields in these text boxes, as I've done below, but I need to bold the word "Note:" in the this text box and can't figure how to. Below is one of the many text fields in this letter. Any help would be...

My main report is just a list of panel names, the sub reports are: 1 - Board Membes (there are 1-3 board members for each panel) 2 - Panel Members (there are many members for each panel) When the first report show in print preview, the first subreport shows fine, but if the second subreport...

Error Message: " is not valid name. Make sure that it does not include invalid char HELP! I've recently been upgraded to Access 2007 and am having this new issue. Everytime I create a query and add a second table to the query, I get this error message: " is not valid name. Make sure that...

I've used this code in previous versions of access, but it gives me an error message in 2007....... strSQL = "tblPanelSessions" Set cnn = CurrentProject.Connection 'sets the connection to current database Set rst = New ADODB.Recordset 'sets the recordset to a new ADODB recordset...

I have a query that has three tables in it, one of the fields I'm using is a memo field. I get the information I need until I make the query Distinct, then it cuts the memo field in half??? After I make the query "DISTINCT", this is what the bio field shows:

I have been upgraded to Access 2007 this morning, and all of my databases that I created in A2003 are giving me problems. When I try to run a query that has criteria looking at another form that is open, but hidden in the database. I keep getting the error message If I go to a co-workers...

Yesterday, I had a database that became corrupted, while one person was using it it appeared okay, when I got in it, it said "The form name "frmSignIn" is misspelled or refers to a form that doesn't exist". Well, I clicked on OK and low and behold, there were absolutely no forms or reports or...

I have a table that has 4576 records. The highest number in the autonumber field is 8270. When I add a new record today, my auto number is 4??? How can it start over all by itself?

Is there a quick and easy way to Close all open and hidden forms with one button?

Did you ever get this to work correctly?

I changed the function to a much shorter one, Option Compare Database Dim objAccess As Access.Application Public Function RptProblem() Application.FollowHyperlink "T:\Wisha db\Training & Outreach\Issues.mdb" End Function On the toolbar, I added a custom button and on the button...

Running Function From Toolbar OKAY, FOUND THE PROBLEM. I forgot the () after the function name. It works beautifully now.

I'm trying to open a different database from within the current database. If I do this from a button, this works beautifully. But if I try and use it from my toolbar, I get an error message: "SHIP (Investments Project) can't find the name 'rptProblem' you entered in the expression" as...