Search results

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...

Remove the subquery from the criteria in the Staff name. You don't need it anymore.

You want to exclude the staff not the training - so this ((Technical_Training.Legacy)<>-1) Should be ((Stafff.Legacy)<>-1) So you need the join to the Staff with that criteria. If that doesn't work please post up a picture of the relationship window with all the fields names for the two tables.

Just take a year off the current function?

If you can buy a display, battery and a keyboard for £45 (that's roughly the conversion to GBP) then it might be worth it. The laptop looks a reasonable spec, unless you want an excuse to replace it. Be warned that changing the display can be very tricky on some laptops, and it's easy to crack...