Search results

If you haven’t changed anything, I’m not surprised. If you have changed something do have the courtesy of showing your revised code, ideally identifying what you have changed

Perhaps OP is storing numbers as text?

You can use the followhyperlink in vba https://learn.microsoft.com/en-us/office/vba/api/Access.Application.FollowHyperlink

Doesn’t take that long - 10 to 15 mins tops (assuming no issues are found) . It’s something I usually do before releasing an app to user testing to clear out all the rubbish

because of the potential for a negative number?

Given the topic title - I wonder how many transgenders play the football and how many serve as the cheerleaders?

editing running code is a big no-no. You can lose everything and is indicative of the behaviour you are seeing. neither compact/repair nor decompile/recompile guarantees fixing your problem. I would create a new db then in order and taking the opportunity to not import anything that is no...

You do need to start with a different seed

Only by modifying the querydef

Not clear whether you are happy for a user to resize/hide columns for their own purposes, just not save the changes. Or you Don’t want them to be able to resize at all. If the latter use a continuous form as already suggested. If the former note that changes to layouts are not saved unless the...

Suspect the OP is confusing compiled with query plans

Agree not necessary (as indeed using relevant names is not necessary) but these days, most of my queries I write directly in sql so using PK/FK obviates the need to specify the table name (unless there are multiple child tables) so save typing. Further it tells me which end of a join each field...

Better to call it customerPK Better to call it customerFK

Access (front end) doesn’t work in the cloud. It is a client based application. If by cloud you mean terminal server or Citrix which runs via Remote Desktop then each user has their own profile- so should work. Each user has their own copy of the front end located locally to them- if you are...

it depends on how sophisticated you want to get. You could have a table of allowed users and your code could be Button.visible =dlookup("username","tblAllowedUsers","username ='" & (Environ(“username”) & "'")<>"" I presume you have other security in place such as preventing users from viewing...

I would use the form open event

You could just check the username Environ(“username”) If it’s not you (or whoever has the authority to open the form) hide the button that opens the form Button.visible =Environ(“username”)=“harry”

a number of templates online - just google 'ms access cash register template' or similar. Here are a couple https://access-templates.com/tag/billing.html

Why would you want users to go into form design view? Just disable the forms allow shortcut property. But this won’t stop a user opening a form in design view from the navigation window. Provide the user with a .accde or rename your file as a .accdr

Hide or unhide what? A control? Lots of controls? A form? A report? Look to modify the visible property- set to false to hide, true to unhide