Search results

Hi, That is what I am doing, once I have selected the product, the UOM should be updated via a query but then I get the write conflict error even though i am not updating the UOM control If I can include the UOM in the product dropdown box, how do I link the unbound control to the second value...

Assuming I add the UOM to the part number dropdown box, how to I get the information of the second column from the drop down box to the UOM control?

I added zero as a default, the query still does not update but I dont get the write conflict error When removing the update query when selecting the product and added to after update on the Qty, it works fine, even with no default value in the UOM control

The UOM control is a blank field on the temporary file I am updating Also not sure why the update query does not run after update and only updates when I do a manual click on the query, and then the write conflict I thought that saving after the update before the query runs would help but it has...

Hi all, Please could you assist? I select a product from a drop down list, after update it should lookup a value from the same table and update my current table for some reason it is not doing the update but when I manually click on the update query, I get the write conflict error My code...

I believe this is what I did but still not sorted by month correctly

A bit in the dark here, sorry This is what I did but can not sort by period as this will give a incorrect sequence by month

I have the 1st query sorted by the actual date Query 2 I did not include the date as I have a sum in this query but the Sort order for month year is not in the same sequence as in the 1st query Not sure how to add a column to sort the second query by

I do have another question How do I sort by month? The Month year is not in sequence This is a sum query so I can not include the actual date to sort

Sorry all, sorted now, the format pulled through incorrectly when imported from excel

Yep, fieldname is correct

Al the transactions in the transaction table has a date Just not sure why in this DB this is not working, I have it set up exactly as in another DB and it works perfect

Hi, I dont want to have any limitations in hardcoding any date ranges

Transaction date is set up as a short date yyyy/mm/dd

Hi All, Please could you assist Month year extract from date not working Date format YYYY/MM/DD Result is all Jan 2022

Hi Doc The sequence starts a zero, when I do any transaction, I will add one first then use that in my document No I dont need this for any auditing but I hear what you say, I will add the prefix only then printing the applicable document

Hi all, I have the below table Each record should have its own prefix as per the sample Please could you advise if possible in one single table

Hi, They will update sales and stock on hand form other locations

Thank you all for the advise For now, I will continue to develop the app in Access and have google sheets updated after each transaction This will not be true live data but will be as close as I will get at this point in time Will look into the other options as advise later on

I googled Azure SQL, yes it is a bit pricy for a small business, at least $300 per month, which is quite expensive A this point in time it will be working only from the office but I need to give agents on the road access to the DB in the near future So I am really stuck here between a rock and...