Search results

Hello all, I have a database with a piece of code that worked up to today. My database connects to sql server. I use cross over queries to run the queries and the queries make temp tables. In the vb code I added one additional query between 2 other queries. then the import stopped working and...

I was using orderby = true instead of orderbyon , so my bad, but where in the code would I place this. I have tried a few spots thinking I just had it in the wrong spot but it still isn't putting the date in desc order. Thank you for this part.

That is one solution, but I would like to have to auto sort for me.

Okay, I am building a database form that uses a sub form. I got the search function to work great, had to copy some code to do so, but now I would like to have the results sorted on a different field. the Search function uses employee id, then I am trying to add me.orderby to the code to sort...

It is a text field.

thanks TJ. I guess I have been in front of the pc too long. when I put this in after click: CurrentDb.Execute ("INSERT INTO historical_tbl SELECT * FROM master_tbl WHERE networkID=" & Me.NetworkID) CurrentDb.Execute ("DELETE * FROM master_tbl WHERE networkID=" & Me.NetworkID) I recieve a...

thank you for the suggestion. I will use this route instead. but would I put the code in the sub form or in the main form?

I have a form with a sub form. when a record is choosen in a combo box the sub form is filled out with a record. what I am trying to do is have a button that will copy that record to a history table then delete it off the the main table. I cheeted by using the wizard to get the code to...

I have two combo boxes in a subform that use lookup queries. I can get the combo boxes to work correctly out of sub form in a regular form but can not get the combo boxes to work in the sub form. I have narrowed the issue to the logic in the queries in the secondary and tertiary combo box...

Hi i have a trigger on a form which once something is choosen goes to a look up table and should auto populate from that table. Since that table has multiple columns I am trying to get the code to choose from the second column. My code doesn't work. help. Private Sub Forum_AfterUpdate() If...

This option appears not available in access 2007.

I would like to build code to open another database I don't want to use a hyperlink because I need to have options when the button is clicked. The vba code is driving me nuts.

hi, I need help making a case statement. I have a form with 9 check boxes. The intent is you are able to choose 1 through eight choices. if you do the 9th check box deactivates. If you unchoose all of them then the 9th box becomes active. If you only choose the 9th box the first 8 becomes...

Since everyone just jumped at the chance to help here is my code so far. Still need help getting the report as the body of the email. Dim strMsgBody As String strmsgbody = ?????? DoCmd.OpenReport "Daily_Text", acViewPreview, "", "", acNormal DoCmd.SendObject acReport...

Hello, I have a very simple report that I need to have in the body of an email. I have a form with a button that should activate outlook, add the simple report to the body of the email and send. The TO: field will be blank due to a distro list. The subject field should also have a standard...