Search results

I would not expect a Product_Code to be a number or an autonumber field. The normal purpose of a Product_Code is to provide the ability to create summary information. I would expect it to be something descriptive about the group of products, not an arbitrary code. You have fields called...

This sort of issue is backend specific. Personally, I would hesitate to change more than 10,000 records at once. My earlier suggestion about being careful had an error in them (proving my point). You need to constrain the records for some queries. " ST" is OK in the middle of the field but not...

Try to see if you can you make the changes by hand using a select query. This may be an edit rights issue.

Be careful with this. You don't want to St. Louis Avenue to Street Louis Avenue. Or change "Stanley Road" to "Streetanley Road". You should be using spaces in front and behind so " ST " become " STREET "

Their answer is not wrong. In Queens, NY it is common to have addresses with a hyphen before the street (like 12-26). How do you sort non-numbers numerically.

Trying repairing your installation of Access.

If you have 90 fields most of which are unique to single record, then they should not be fields at all. You should have a "Comments" field with a "Long Text" type where you can enter free-form information.

I came across the following curious situation at work. I need to compute the average lot size of parts being produced. The obvious thing would be to divided the total number produced by the number of orders. However, my interest involves setup costs, so it is more logical to ask for the each...

Search & Replace in the SQL window is handy. I am glad you mentioned it, I have not seen any documentation of the recent update.

13426.20404

During the last update in Office, there were a number of changes made in Access. The most annoying change I have found so far is in the Query Design screen. When you add a table it splits tables into Tables & Links Now to find tables, I need to know whether it is local or linked (most are...

Does Power Apps allow me to setup a proper relational database?

My daughter's company needs some customized scheduling software (her firm is running on-line D&D games for kids). Given the remote nature of her workforce, web browser solution would be best for users. Would this be better handled through Microsoft Power Apps or with Microsoft Access and a VPN?

Are you sure defined this correctly? I would expect that quote numbers be assigned sequentially (AutoNumber) and then displayed in a sorted recordset. Why is there a need to renumber anything?

Yes, it is. I have the same problem with much larger databases, so I was surprised when this small database crashed frequently.

I imported into a new database. I will see what happens. Does it mean anything to decompile a database that has no code?

I have been having problems with Access crashing when a table is selected. Access generates a backup file during this crash. This has been affecting multiple databases over the past few months but this particular small database crashes half the time. Does anyone have any idea about why it is...

I don't see that option. I did uncheck "Name Autocorrect".

This happens when there are no other users in the access database. As this happens with access native tables as well as sql tables, I assume that problem is on the access side.

Over the past few weeks, my main work database has developed a problem where it locks up when opening table interactively. The problem occurs with both Access native tables and SQL server linked tables. It does not happen when things are running without user interaction. Repairing the database...