Search results

I have a button that opens up a form with a dlookup function that automatically fills out the fields in that form. I have attached a sample DB to save time explaining. SectorF contains a list of Stations, double clicking opens up the StationF which contains a list of buildings. Double...

Users are viewing a record on a form that gets it's data from a query. I want to make it so that if they edit that record from that form, a last updated field will timestamp the date/time that the record was edited. I added a lastupdated to the source table which of course adds it to the query...

Users are viewing a record on a form that gets it's data from a query. I want to make it so that if they edit that record from that form, a last updated field will timestamp the date/time that the record was edited. I added a lastupdated to the source table which of course adds it to the query...

I have a label inside an attachment box on a form that tells the person using the form how to attach a file. I want that label to disappear if an attachment is added. I entered this code in the form current event and it makes the label disappear even if there is an attachment. Is it in the...

I created a button that will generate a report in pdf format and I want the form to remain hidden but I want the outlook email to open up with the pdf report attached so that they can just enter whatever email they want to send it to and click send without even having to open up outlook. I...

Does this help?

Table 1 has FieldID1 and FieldID1Name Table 2 has FieldID2 FieldID1 Field ID2Name Table 3 has FieldID3 FieldID2 FieldID3Name Table 4 has FiledID4 FieldID3 FieldID4Name The form for table 4 contains a button that opens another form where the values for FieldID1 FieldID2 FieldID3 and...

That did it! Thanks! I do like the enabled false better too!

So I only want certain buttons to show up after a record is saved. I entered the following code and the buttons stay on the screen even if it's new. If Me.NewRecord Then PrintWorkOrder.Visible = False WorkOrderComplete.Visible = False Command54.Visible = False...

I thought about that when I put them in those events but I couldn't think of another event to put them in.

I'm trying to have an unload function that makes sure the user wishes to leave the form before it automatically resets the information in case they accidentally hit the exit button. But every time they hit the button it resets the form BEFORE it displays the message. Here's the code I have in...

I'm trying to figure out how to stop my database from trying to load access in design mode before it goes to my startup menu. I borrowed macros from a database just to get this far but I don't know how to make access go straight to the main menu rather than load the design mode and then go to...

Annnnnnd success. Again, pbaldy saves the day. Thank you!

Ohhh. Yeah, but that doesn't undo the filter. Even unchecked, the filter is still on.

I'm trying to filter a continuous form with a filter using a checkbox where when you check the checkbox it applies the filter and when you uncheck it, the filter is taken off and all records are shown. But I can't get the check = false to take the filter off. Private Sub Check19_AfterUpdate()...

Thank you SO much Plog and CJ!!!! Finally, this thing is done! I can't thank you guys enough! Thank you!

Sorry didn't attach last one.

I attached a sample here.

Sorry about that Plog. I tried yours but it keeps telling me to enter a parameter value for ProductID.Description.

What about if the date isn't just a year? It's a whole date like 1/1/2013. So when I try to run the query it says "This expression is typed incorrectly, or it is too complex to be evaluated. For example, a numeric expression may contain too many complicated elements. Try simplifying the...