Recent content by mnunan

Thanks very much everyone, I used CJs example and it works perfectly. Much appreciated.

Hello all I need a little help with a query please. I have a report based on a query which has some calculated fields. Subtotal: ([journey_price]/100*90) is an expression in the query which deducts 10% off of the journey price. This is then used for other calculations. What I need to do is...

Thank you for your help. I didn't want to completely redo the form as there were other fields to consider but from your advice I went down the route of using a subform based on a query instead. Thanks again

Hello all Could someone please help me with the following: Table 1 = Contacts Relevant fields = First Name, Last Name and ID Table 2 = All Jobs Relevant fields = driver_id I have a form with an unbound text box and want to display in this text box the first name and last name from the...

Yes I did try but it didn't work, fields were returned as blank regardless of whether they contained a value. The code that i posted returned 01/01/70 01:00:00 if they were blank so someone on stackloverflow kindly posted a response of IF(FROM_UNIXTIME(datetime2,'%Y') = '1970', NULL...

Hi Sorry it isn't a function, it is just a query from a web application to a mysql database? Thanks

Hello I have the following query running from a MySql database and need a little help please. I need to return a 0 or just blank field if FROM_UNIXTIME(datetime2,'%d/%m/%y %T') is blank, could anyone please help me with modify the statement please? SELECT names, phone, returntrip, cprice...

Hi I don't know if there is a way to turn it off in queries like you can in tables and forms but I have found that if I use a expression in the query (for example I use two expressions to put the date and time from a date/time field into two separate fields like dd/mm/yyyy and hh:nn:ss) then...

Sorry not to worry, I found the solution on another forum and it is due to a slight error in the instructions for referencing the classes on Dev Ashish's site. Fixed now and working great! Thanks for all the help

Excuse my ignorance, I imported the addin as described in the link you provided, does the code not reference those imported classes? If you could provide some step by step that would be great Thanks

Hi pr2 and thanks for the welcome. That link was very helpful thank you, I wonder if you are able to see where I am going wrong (bit of a novice with VBA!) I have the following code which while it doesn't throw any error, it doesn't do anything. Now I think it is because it isn't actually...

Hi I have a button on a form which runs a query, exports the data to csv and then opens that file in excel for checking. This is my code which works great: Private Sub RunStatements_Click() DoCmd.TransferText acExportDelim, , "StatementReport", "G:\jobs.csv", True Call Shell("""C:\Program...

Hello Could anyone help me with this issue please. I have been searching for 2 days for a solution that works for me but have yet to find one, and I have looked at cascading combo boxes too but I just can't seem to get it to work. I have an unbound combo box (cboGoToCustomer) on my main form...