Search results

I'm using the after update to create a corresponding record in a different table which is displayed in a sub tab. Private Sub FormProjectCode_AfterUpdate() '------------------------------------------------------------ ' This code fires after the project code has been entered on the Invoice...

Hi, I have a date entry field that I need to fire an action once the field is completed. I was using a Form.AfterUpdate event to do this, but my end users reported it wasn't working... Private Sub FormProjectCode_AfterUpdate() after looking here ...

Wow. I don't know how I missed that. This works brilliantly now. Thank you for your help and advice !

Thank you for your fast reply. I'm still getting stuck when there is no date added to the RPIDate field and it's still returning error 3134 : Syntax error in INSERT INTO statement. I think it still wants something entered into the VALUES section... I tried forcing a 0 in there somehow...

Hi, I am using the below adapted code to insert multiple invoices into a database. http://stackoverflow.com/questions/36061026/need-help-to-amend-access-sql-statement-to-loop-through-fields-in-a-subform I have included the below function to help with the US/UK/SQL dates issue that I always run...

Yes ! That did it. Thank you so much, I have so much trouble with the single and double quotes - I'm going to pick apart that formula so I won't have so much grief next time ! :D

I've been trying for hours to fix this without assistance, but just can't get my head around the syntax. I need to combine these two statements into one DSUM, both of the criteria are strings : =DSum("[InvoiceValue]","Qry_QTRRecon","[FY]='" & [form_cfy] & "'")...

Hi, I found the answer to my problem : 'Hide navigation buttons From NonAdmins If UserLevel = "Admin" Then 'Show full navigation pane DoCmd.NavigateTo "acNavigationCategoryObjectType" ' All Objects DoCmd.Maximize 'Hide Manage Employees...

Hi, I'm needing to find a way to hide almost all of the access objects in the navigation pane, but not all of them. I've found that I can create a navigation group and add the form (or two that I want to be still available)...

Solution found here : http://stackoverflow.com/questions/36061026/need-help-to-amend-access-sql-statement-to-loop-through-fields-in-a-subform

Thank you for the suggestion. However, I have the above working fine in it's current state and just need to add 2 fields to it. I'd rather not have to start over and create a large query from scratch that deals with adding specific fields to different tables. I wouldn't know where to start -...

Hi, Hope this makes sense. I have adapted a code to allow me to create a report entry form for invoices. Original code : http://windowssecrets.com/forums/showthread.php/37448-looping-through-fields-(Access-2000-SR-1) I have a subform (created from tbl_RepeatTemp) with a single field...

Thank you. This gave me the start I needed to get this sorted.

Hi, I hope this makes sense. I attach a zipped copy of my database in the hope that it clarifies my request. I am needing to add RPI (tax) to an invoice value under certain conditions : a) That an RPI date has been entered b) That the RPI date is used to then find the correct multiplier to...

For my own reference I added a report flag to the Private Sub btn_Report_Click() Private Sub btn_Report_Click() Dim stDocName As String Dim ReportFlag As Boolean ReportFlag = True On Error Resume Next Me.frm_ClientSearchSub.Form.RecordSource = "SELECT * FROM...

Ahh I see. By removing the sort order/direction it works again. Thank you !

SELECT tbl_MainData.RowID, tbl_MainData.RecordID, tbl_MainData.InvoiceID, tbl_MainData.ScheduledDate, tbl_MainData.ProjectCode, lkp_ProjectList.ThirdParty, lkp_ProjectList.AccountName, tbl_MainData.InvoiceValue, tbl_MainData.Commissionable, tbl_MainData.TransactionType...

A query (Qry_ClientSearch) that controls the subform

Hi I'm using an adapted version of this search form : http://www.access-programmers.co.uk/forums/showthread.php?t=99353 It works how I expect, except that when trying to run a report based on the search results I get the error "Run-time error 3075 - syntax error (missing operator) in query...

Hi, Thank you so much for your offer of help. I took a version of my database and cleared it down to make a simpler and annoymous version of my data - and it worked fine ! I therefore went through all the code that was different to work out the issue. I figured out that I had an audit trail...