Search results

There has to be a way and I am probably overthinking this. Anyway, I have a field where the mechanic inputs labor amount. They enter this in standard time format. I need to be able to add this time up and give a total of labor. I made the field in the table date/time and the format short...

You can create a command button (click cancel when the wizard starts) then in its properties -- on click -- put the code that GHudson stated. That way, when ever the end user clicks on that command button, it does the transfer. Hope this helps.

You can use another controls contents in a hyperlink situation. However, in the situation you described, you are probably better off to use: docmd.openquery "queryname or the path to the textbox" In the textbox the user could put the query name to run if the knew it. or CurrentDB.execute...

Use this code then: After Update property for ComboRequestor If MsgBox("Is the Submitter the same as the Engineer?", vbQuestion + vbYesNo, "Engineer") = vbyes Then [ComboRequestor] = [ComboEngineer] Else forms!formname![ComboEngineer].setfocus End If If you need anymore info, give me your...

True..but this is a networked database. The front end resides on the site server. The good thing is, that 100% guaranteed this DB will be opened at least 6 times a day. I was thinking autoexec though. Thanks for the input.

I am attempting to automate a query. I have an append query that I currently manually run. I want it to run one time at the beginning of the month. I have been trying to figure out how though. I think that when on DB open it needs to check the last time it ran. If it was last month, then...

Use something like this: If MsgBox("Is the Submitter the same as the Engineer?", vbQuestion + vbYesNo, "Engineer") = vbyes then nameofcombobox = engineer else docmd.openform "formname" endif NOTES: I would personally have the engineer textbox visible on the same form so that way you could...

Use the same form. Just add a command button to go to a new rec on click.

It could be, don't hold me to this, but Access and Excel both have a 255 character limit (for a text field in Access and per cell in Excel.) I have analyzed files in excel with no issues, as long as I used analyze(tools - office tools - analyze). When exporting I have had a few issues. Hope...

Sweet your first kind of worked...had to use commas here is the code: =Sum(IIf([vehicle description] Like "*sand*",1,0)) Thanks Nirious!

Its actually a group footer. I have about 14 other textboxes doing the same stuff but without the like statement. They work fine. Here is an example: =Sum(IIf(Left([vehicle number],1)="e" And [speciality]=False,1,0)) Works great...I just can't figure out how to do the like statement...

All, I have been trying to figure this out. I have a textbox in the page footer with this as the control source: =Sum(IIf([vehicle description]="" Like "*" & "sand" & "*""",1,0)) What I want it to do is search all of the vehicle description fields (its bound text box is in the detail) and...

I have a wierd problem. This works sometimes but not always. I know, I know I have a bad naming convention as well. I have a form that has a subform on it. The subform has 7 subforms on it. The problem is this: On the main form I have a text box with the control source set to...

Confusing as that is, try this SQL statement: SELECT * FROM table_name WHERE tblTicketDetails.TDate BETWEEN (([Forms]![FrmTransactionRptParameters]![TxtFromDate]) AND ([Forms]![FrmTransactionRptParameters]![TxtFromTime])) AND (([Forms]![FrmTransactionRptParameters]![TxtToDate]) AND...

I believe you can use these, don't hold me to 'em but it might work. This is more of a make table query in SQL: SELECT * INTO ctest IN 'path_to_DB' FROM ctmat WHERE ctmat.est_id = ctest.est_id; This is more of an append query in SQL: INSERT INTO ctest IN 'path_to_DB' SELECT * FROM ctmat...

With Access you can do everything that you have asked. There are macros in Access. Some people's opinion, myself included, is to always hard code the operation in VBA. This is sometimes out of scope for part-time users. These forums are usually very helpful. Most of the time a question has...

The reason you are not getting a result is it is searching the field comments for exactly what you typed and nothing else. You will need to use wildcards in order to get the search (*). I would think you could use this in the criteria field: Like "*"&[Enter search word]&"*" I think you can...

I think this is what you want. Check out the query. If not please explain further.

yes to both questions. I believe, but I will check in the morning, that it is currently setup as archived access and not shared. THe DB itself is setup as shared access though. My servers are archived. But the group that owns the folder has all rights on all three servers. Everyone can view...

I use the code form the link as well. It is one of the better ways to secure a form. However, and I mean however, make sure you diable the close button on frmPassword otherwise if you click on the x it closes the form and opens the form that you wanted to secure. Other than that, perfect.