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

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?

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

Hi, I'm using a tab control form which has 8 different tabs. I have a help document and I have a help button on the bottom of the main form. If I click on a tab and go to that page, I want a variable to hold the page number so the help document can look at that variable and know which...

I have a form with a tab control which has 7 tabs. Each one of the seven tabs has one or more subforms. One of the subforms has two subforms on it. The main subform is personnel information. The first of the two subs has address information and the other of the two subs has phone/fax info...

I Am trying to insert data into a table --- some of the fields are coming from a different form (frmHold) DoCmd.RunSQL "INSERT INTO tblReportResults1 (AppID, DocumentID, ReportType, RptDate, ProjOff, ProjContactPerson,) VALUES (" & Forms!frmHold.AppIDHold, Forms!frmHold.DocumentIDHold...

Has anyone found a way to enable having a Continuous Form in a Continuous Form? :):):)