Search results

Does anyone use tables anymore? I thought ChatGP stored everything....

I used to do this for previous repairs - a small list box with the previous job numbers and dates, most recent first. You could select any previous repair and see a pop up of the main repair data without leaving the current job.

Welcome Alessandro - I've followed you on linked in for a number of years. Ciao!

I think it depends on scale and number of transactions. If you are only dealing with a few hundred stock movements a month, then you should always calculate. If you are dealing with tens of thousands then I would probably have a routine to calculate and store it, to keep processing speeds...

It will be something to do with the report section settings (header, footer, detail, etc) , possibly force a new section/page after ... You will need to fiddle with all the settings to find it I'm afraid. You can tell in print preview how many pages it will be using, so try layout view and see...

Have you made the folder the Access database is in a trusted location?

I'll chuck my 2pence worth in here, as I had to deal with FIFO pricing for COGS at a previous place of work, and it's an unmitigated PITA. If you can possibly avoid it I would. From memory, we eventually manage to talk them into doing average cost based on stock held and date based purchased...

Possibly a daft question, but what format is the data in that you have downloaded?

You also need to add the form reference to the second instruction: Me.RefundSearchSubFM.Form.Filter = FilterSTR This >> Me.RefundSearchSubFM.FilterOn = True Should be Me.RefundSearchSubFM.Form.FilterOn = True

Just to chuck my 2p worth in here, in my experience CF definitely works more slowly on Azure SQL linked tables than Access ones. I have improved this sometimes by setting display "flags" in the views I connect to and using those to control things less intrusively than CF.

That would suggest (rather obtusely I'll admit) that Me.[Contact ID] is null. After you set strWhere add the following line Debug.Print strWhere & " " & IsNull(Me.[Contact ID],"Its Null!") And see what you get in the immediate window. (Press Ctrl + G in the VBA editor to make it visible if it...

I looked at in anger properly about 5 years ago. I didn't find it very intuitive, but I could see how an untrained user could probably get something useful from it depending on their ability to "click and see what happens" as the desktop version UI (was) is quite user friendly. IMHO, it...

What's the error being reported as ? A clue would help. Also can you edit that and put it in code tags (Press </> option in the editor and paste it in ) Edit : if you can Indent it and format it a bit better it might be more readable within the code tags as well.

Some Providers will provide static IP but remember it will only be for that site. A VPN can do this but will still only work for one site at a time, if people are using mobile hotspots, they would (I think) need to be connected to the same network/VPN.

If you brought all those fields into a Product combo box, (hidden from view) you could simply display them from the hidden column directly, no need to fill out that data separately at all. If the product description doesn't ever change then you don't need to store it on the order, you can...

On SQL Server UPDATE TheTableName SET Selling_Price = Purchase_Price * 1.3 Replace TheTableName with the correct name for the table. EDIT : Actually re-reading your post I think one of us has the calculation wrong? I assumed you just wanted 30% Purchase price + (Purchase price *30%) is a much...

So if she is found guilty, presumably she'll suffer the same fate as Trump then?

Check the battery is seated correctly, charged up, and that any mechanical switches it might act on when in place are working.

Before database work, I had been repairing electronic devices for 20 years for a living (including Toughbook's, and other dedicated specialist portable PC's) and undertook a similar repair on my daughters laptop (An HP with a touch display) a number of years ago. It was a nightmare, they really...

Okay - I'm not sure your data is stored in a sufficiently normalised structure to do this. Currently you only know what courses someone has taken. If you had a new course you wouldn't know it existed as it's an unknown quantity. You really need at least three tables : tblStaff - with the...