Search results

If the data types of EmployeeID and BenefitsID are numeric, then; DSumAmt: DSum("[deductionamount]","tbpayrolldeduction","[employeeID]=" & [tbpayrolldeduction]![EmployeeID] & " And [BenefitsID] =" & [tbBenefits]![BenefitsID]) If the data types are text, then; DSumAmt...

Were the bulk of the modifications to the front end or the back end? The data should be in the back end (you did say that this is a split application), which should not be a MDE file, the MDE should be the old front end, separated from the data. If your modifications were to the front end...

Sorry, the slightly different answers above might just confuse the issue for you, do what MarkK suggested.

See the example below. The line in red is what you need to add to your code. Private Sub btnSearchCarlsbad_Click() Dim strString As String Dim strText As String Dim strSearch As String strText = Me.txtSearch.Value strsearch = "Select* from Carlsbad where ((LineItemCode like ""*" & strText &...

It is generally not a good idea to store data in this manner, however, if you want to do this I don't really see a need for a Select Case here based on your description. You are going to use a combo box with weekday names (based on another table, or value list). After the selection in the combo...

Have you tried just using a composite key on Word1 and Word2 in that table?

You were on the right track with the Not In clause, so i'm not sure why you switched to using the Not Exists clause. The reason that won't work is because it is going to look for a License that matches the literal string "License 2, License 8, License 13". No such License exists in your License...

This is not fully tested, but you might give it a try. Replace the text in red with your actual field names. Note that in this case I declared the lngRecordID variable at the top of the module, not inside the Current event. Might need some other tweaking but it did work with some minor testing...

How do the users currently navigate the form? Do you have your own navigation buttons created so you can control the flow, or are they just using the built in Access navigation options?

If you want to be able to leave the WkEnding text box blank upon opening the form, then you are going to have to wrap your DLookup in an IIf statement. It would look like; =IIf(Nz([Forms]![Form1]![txtWeekEnding],"")<>"",Nz(DLookUp("PayIns","tblDepositInformation"," WkEnding = #" &...

You need to do both, split the database and set correct permissions for each user.

You also need to verify that all users have Modify permissions for the folder on the server where the back end will be located. If they don't have the proper permissions then the lock file can't be deleted when the close out of the front end.

I might not have explained well enough the first time. I am re-attaching your db. If you open the report in design view and go to the properties for the BoatHeader section, then the Event tab, you will see "[Event Procedure]" in the On Format line. If you click the elipse (...) to the right...

Did you try any of Steve's suggestions from post #22?

Keep in mind the Format event only fires when you print the report, or view it in Print Preview. It doesn't fire if you are just viewing the report on screen in Report View

That may be true, but the report is based on a query that is using an outer join, so the resulting recordset would normally include records that have a null value in the BoatMake field if not all members have boats. Any chance you can upload a small sample db that duplicates your problem so we...

Try this; Open the properties for the BoatMake Header section of your report, go to the Event tab and in the On Format event put Cancel=IsNull([BoatMake])

Setting the Cancel argument in the Format event of the report section where the BoatMake control is might solve your issue. Can you show us the design view of your report?

Yes, users who do not have the full version of Access installed can use what is known as the Runtime version. This is (in most cases) a free download that can be installed on a client's machine so they can use an Access database that was created by someone else. You can find more information here.

Have you considered either linking the excel file as a table, or importing the excel data into a temporary table, then using queries to remove the garbage and/or select only the data you want. The only thing I see in your code that would need to be resolved is the fact that you are relying on...