Search results

OMG! You solved my problem. Thank you so much. I can leave work now with a clear head!

Hello, I am trying to multiply 152 by .94 in a calculated field in my query to get the total cost. The query returns $142.76 but the correct answer is $142.88. I have read that it is a rounding issue but I can't understand how to correct it. Any help would be appreciated. Thank you

Hello, I tried the code suggested and got an error message when compiling: Compile Error: Sub or Function not defined. Else ChangeProperty "AllowBypassKey", DB_BOOLEAN, False Any idea how to correct it? Thank you!

Moake & Solo thank you both for your detailed suggestions. I really appreciate the time and effort you spent to help me out. I am going to try out your suggestions when I get back to the office on Monday. I will let you know what happens. Thanks so much!

Update- I'm sorry I left out info on the error: Error Message is "Run Time Error 3270" and the "txtBypass.Value = CurrentDb.Properties("AllowBypassKey") is highlighted.

Hello, I have the code below attached to 2 buttons on my databases Main Menu to disable/enable the bypass key. I also have a text box on the Main Menu named txtBypass that displays “True” or “False” depending on if the bypass is enabled or not. I recently converted this database from Access...

Thank you Pat, that's an excellent suggestion because these Machine names are likely to change. Some will be added and others will be deleted over time. It's nice to know more than one way of solving my problem. Your help is very much appreciated!

That did the trick! Thank You Again!

Thank you I appreciate your help. So something like this: If cboActID = "P And cboMachID <>F-123-D And cboMachID <>F-45-D And cboMachID <>ABC-D And TtlItems = 0 Then MsgBox "You must enter total items"

Hello, I have a form which includes fields for a Machine Name (cboMachID), Activity ID (cboActID) and Total Items Processed (TtlItems). I need to write a vba statement for the forms before update event that checks the following: If Activity ID = “P” and Machine ID is not equal to (“F-123-D” or...

Hello, Thank you both for your replies. The form Start and End dates are unbound and I close the popup when the report closes. I tried NauticalGent's suggestion and added the code to the On Click event of the button that runs the report. When I clicked the button the popup form opened as...

I have a popup form that prompts for start and end dates before running a report. When the user enters the dates and clicks "OK" the report is displayed correctly. My problem is that once the user closes the report and runs the report again, the popup displayed has the same dates in the input...

Hello Mark, thank you for your suggestion. I was able to find a perfect solution for my project here: http://www.databasedev.co.uk/downloads.html. It is a pop up sort form that was intended for sorting a report on the fly in print preview mode but I was able to adapt it to work for my form...

I have created a search form which displays results in a continuous form format. I want users to be able to sort the results by multiple fields, remove the sort, then if desired, sort again on different fields. I have both text boxes and list boxes on the form. Can anyone give me an example...

I found it! Here is where I added the "AND": strWhere = "[lstMachID IN (" & Left$(strWhere, lngLen)& ") AND " Thank you for your help.

I think I am getting closer with this list box but received the following error: Run time error '3075' Invalid use of '.','!', or '()'. in query expression '[lstMachID] IN ("E148","E161","E995")([WorkTypeID] = "P2R") AND ([ActivityID]="P") AND ({ProdDate] >=#06/15/2017#) AND ([ProdDate] <...

Yes, Data entry operators enter employee’s production volumes and time spent on machines from production logs that the employees fill out every day. Some fields on the form are Employee Name, Job Number, Job Type, Machine Name, Total Time, and Total Volume Produced. I currently have combo...

I'm sorry, let me try again.

I have created a search form based on code from Allen Browne (see attached) that works very well, however, I need to add a couple of list boxes to the form. I want the user to be able to select multiple values from the list. Can someone give me an example of adding 2 list boxes to the attached...

I have a question about the 6-9-2014 post by Frothingslosh. Where would I place the CheckFrontEnd() function for this to run when a user opens the database? Thank you