Search results

I tried sorting by name and date, then running the macro but if I do that the macro doesn't give the right sum.

Hopefully someone can help me with this. In the attached spreadsheet there is a VB macro that looks at the info in the spreadsheet, seperates it by date, and then gives a sum of the times on the sheet. What I would like to do is be able to sum by name instead of by date, but I cant get the...

Figured it out. I was referencing a key field from the wrong table.

Added the error message and finally loaded the database.

Can someone go through my forms and help me figure out why I cannot submit the entered data. Whenever I try to test my system and enter in inspection information I get an error that says.... "The changes you requested to the table were not successful because they would create duplicate values...

I'm using Date(). I tried setting it up a different way, but I get no result here is my 2nd attempt. **User is supposed to enter current Date in "txtDate" text box then press Date_Toggle button.** Private Sub Date_Toggle_Click() DoCmd.OpenQuery "qry30_DAY_ALERT" If...

I have a timed form that opens when my db loads. When the form closes a query is run that pulls time sensitive records from a customer table. I am trying to set up another function on my form that takes the system date from a text box on my form(already made) and compares it to a field in a...

Thanks! you guys are amazing. I didn't think of setting it up like that.

Is there a way to append a specific record entered into a form to a serpate table based on a form entry? ex. When a user types the word "true" add the record to tblTrue, but if the user enters the word "false" add the record to tblFalse. I'm tryin to do this because the company I work for has...

I'm not getting a Display Control option in my menu. This is access 2003 btw if it makes a difference.

I'm having a problem getting my yes/no boxes to work in a query that i'm using. Instead of showing up as checkboxes in the query they show up -1 & 0. Here is a snippet of my code. The MWS field in bold is supposed to be a checkbock but it just shows up as <tablename>.MWS in my query...