Search results

Seriously, think very carefully about deleting any records. You could just mark them as "dead". The real question is how are records being entered that turn out to be not required? Are users misunderstanding something? Is the database or code not working correctly?

Seriously? That might be an almighty task if it's a big database. Are you trying to rewrite it or something? I can't think it's just for academic interest. The buttons themselves may not reveal much anyway. You need to understand the data tables and relationships. Once you have that, the...

Actually three characters was enough to remind me of the password I had used a long while ago. It was after that experience I stopped using passwords.

If you want to find the largest date from a subset of a table/datasouce then Dmax(datefield, datasource, filter string ) will select the highest value. This assumes your dates are defined as date fields, and not text strings.. I don't see any circumstances when this will not return the correct...

I was thinking you meant tracks as in album tracks. You mean tracks as in multi track recordings. Is this dealing with mixing settings as well then, where you can increase the volume of individual elements, and other stuff that's so far beyond me I have no idea. When you say track zero is the...

What are you actually doing? Writing songs with samples, and effects at various points? Can you describe the structure of a song, and list the data elements you want to store in the database? Are effects applied to the song as a whole, or to sections of a song. Or both?

The idea of a password is to make it hard to crack. It's a bit late now, but the best solution is not to have a password at all in your personal development environment, but add a password, if you must, to a published copy of the database. That way you always have the development copy you can...

I thought you needed A2003 to read A97. It's useful that you can use A2010 I used to have each major version of Access on my PC, but now I have only A2003 and the current version.

I don't know if you have back up databases. Maybe delete the form causing the issue, and reimport from a back up.

I imagine one of the reasons there is no reverse dlookup is the problem of dealing with non-unique responses. Dlookup returns a random or maybe first instance of a successful search. Therefore a corresponding dput would not know which record to update, and needs to be stated in a different...

I'm not sure offhand, but you would need to check whether datediff("y") rounds values If not then you could say this sort of pseudocode. Sorry, I can't select a block of text on my phone. If datediff ("y") >=1 then Result = datediff("y") Else Result = datediff("m") End if

I have W10 A2003 peacefully coexists with Office 365. Never had an issue.

I haven't read the whole thread, but I wouldn't be surprised if you could still manage these values with DAO objects. I thought the issue was that all users are granted admin rights in later versions of access so anything that examines membership of other groups will not work. Within a...

And there's a whole new lot of stuff to learn to become proficient. Not easy to find another 1000 hours.

But all of this can't be magically done by AI. The developer needs to understand the problem, and write code to manage the transactions accordingly. You can probably develop a function to take any quantity for a given SKU, and translate that into an appropriate quantity for another SKU, (the...

My stuff isn't error prone. I have very few service calls, touch wood.

Just to add a comment. Well if you are transferring stock from location A to location B, then you need to add a minus transaction to indicate that location A, product X, pack type P1, has a new transaction of negative Q1, So you might have moved -100 widgets from location A Now you also...

Yes it's not secure, but you can still use an access front end with a secure backend, but then you need IT people to help manage the BE instance. (or you need more skills)

The trouble is, everyone and their dog writes excel Spreadsheets, some ok, some not. They never use code, and businesses make them mission critical documents. The same users think they can build a database in the same way as they build their spreadsheets with no conception of the completely...

Is your combo box not bound? That might be an integer rather than an object.