Search results

Presumably you know the log in ID of whoever is logged in? You need to use that as criteria for that update statement, otherwise it will simply update everyone (as you have discovered). I suspect you also want to record that same ID in your login sessions table so you know who has logged in...

You'll probably need to create two recordsets, one of the Parent data and one of the child data, and loop around the Parent data, and then pull in the matching child data. If you genuinely only have one child record per Parent record then it may be easier in a single recordset.

Welcome to AWF !

After you have tested it... I suspect you won't get anywhere if your network has any sensible security settings. The only way this might work is if you installed a secure VPN and log into it from the other networks.

I would disagree depending on how you are actually storing the ancillary order information. If you are creating multiple line item invoices, I personally wouldn't want to store the PO, Contact Details, Order delivery instructions et al. on every line? That seems very wasteful on storage (which...

Welcome to AWF. Two things - is this a class assignment? And show us your table structure, because if it's laid out as above you have much more serious problems with the way your data is stored.

Wow, that's a really serious wildfire. I hope nature can contain it or put it out as I doubt us poor little humans can.

You have to store the VAT per line, as the line items might have different vat rates. No choice. For a suppliers invoice I would record the VAT they charged per line regardless of the calculation. Using one form for both would be problematical, but not impossible. I'm not sure I would go down...

You need to check the record count in the subform first, something like If Me.frmOrderAddEquip.Form.Recordset.RecordCount = 0 Then ...

But, if it was simply ticked by default in new databases, it wouldn't cause a problem in existing ones? And noobies would get an obvious error in their code?

We had no issues with Amazon returns, and we use them a lot, but always price check, and check the supplier direct if possible. UK based, and Amazon are very helpful normally.

Have you tried removing any internal margin settings: I have seen some odd effects, particularly on combo boxes, when these are anything other than 0 and coloured backgrounds are used. They might be exacerbated by the scaling in the environment.

You have a typo in your function Interal = "m" But suspect that might be an editing issue rather than you source of your problem. When you remove the criteria, sort your results on the calculated expiry date (ascending and then decsending , and see what you get. If you can't spot the error...

That will restrict you to exactly 6 characters. If it's an unbound form then in the "Change Password" command button use something like If Len(Me.MyNewPasswordControl) < 6 Then msgbox "The new password supplied is not long enough",vbInformation,"Check Password"...

I suspect it's links, even to other posts. You can't post links until you have a 100 posts to prevent spammers / advertising.

I wouldn't mess with that - it's used as a temporary store for the data whilst Access is doing the compact and repair. It sounds as if you have it set to compact on close, which isn't generally considered good practice?

The DATABASE.mdb file is normally created when a compact and repair is run on close.

Try displaying a report in a form, that would possibly work as you can change the font per detail line in the format event?

@emmanuelkatto , @emmanuelkatto23 , @emmanuelkatto24 You are going on my ignore list as you have failed to respond to any of the answers provided in any of your myriad questions. This tends to make me think you are either a bot, or a wind up, or simply here to waste peoples time.

I can see a sensible pattern to work with but what I can't see is the source data. In these circumstances it is often better to have two samples - The data you have to start with and the secondly the desired output. So ideally we need two excel sheets - starting data, and expected final output...