Search results

I converted a macro to code. The macro had two queries ... the first one (Delete_tbl_Temp_Items), which deletes all entries in the tbl_Temp table. The second query appends the results of "CurrentTeachersSvcTag" to the tbl_Temp table. (I chose to delete the data and append the query results...

I am not fluent in VBA, so coding is very difficult for me! I could not figure out how to use the DCount, so I tried using DLookup to pass the value in a query field, but it's not working. ---In this example, "frm_RepairInfo-Asset" is a from based on the query "RepairInfo-SearchByAsset". ---I...

I have a db where users can search for various things, which could be alpha, numeric, or alphanumeric. Right now, the code stands as such: DoCmd.Close acForm, "frm_RepairMenu" On Error GoTo fErr DoCmd.OpenForm "frm_RepairInfo-Notes" Exit Sub fErr: DoCmd.OpenForm "frm_RepairMenu"...

I have a database that, when I send out a new frontend, the users have to enter their defaults (their name and location etc). They often forget to set these, even though I tell them to set them in the email announcing the new frontend. So ... I created a form (frm_SetDefaults) that has a...

I have a query that parses out apostrophe's in student names. In some instances, there is no student name. When that happens, the results are "#Error" for both FirstName and LastName. (Because I'm forcing the field to be included by way of joins). The formatting for that field works unless...

I have an insert into statement that is 1,082 characters. Is there a way to get around the line limit? I've tried using " _" in the code to signal a continuation on the next line, but it doesn't like it. What are my options? Thanks.

I have a table that used to require the user to enter the ticket number, then clicking on a button would create that record and open that ticket where user enters more info about that ticket. Now the ticket number is auto-number (I got that part to work with an append query) ... but the code...