Search results

It's better to make it foolproof, than find you got rogue data into your system. :D

I think there's 2 options. Either accept the data columns without checking, or specify the column headers. (Maybe this is importing a csv, rather than a spreadsheet.) For safety I like to check the column headers are what I expect. Especially as it's always possible that the spreadsheet my...

Do you mean design changes, or data edits? Edit - looking at the previous thread, I take it data. Do you mean reverse the change after the edit and update has taken place?

And from the sound of it, they already have a working system.

@Technics You don't do a night shift do you? If you have employees clocking on at 6pm say, and finishing at 2pm, you now have different days for each time stamp, and this will need to be taken into account.

Or Remove 64 bit office, and install 32 bit office. Part of this is caused because MS used to install 32bit by default, and now installs 64 bit. As I just found out, it's very difficult to remove 64 bit in order to install 32 bit. It just said "cant install 32bit". It didn't offer to...

It's good to see a lot more answers on this, but I thought the real question the OP was asking is whether the functionality of a commercial system would be better than the system that was already in place.

I've not read the whole thread, but surely a few product descriptions doesn't matter Add a column, number probably Mark the active items as 1 Mark the archived items as 2 Mark the redundant items as 3 Then you can cascade delete all of the "3" records, and any related records, deal with the...

Well runtime will crash instantly on any unhandled error. If you were getting errors on your old machine that you could recover from, you will not get that opportunity to resolve the problem with run time. You are OK running well tested apps on run time, but you still really need a...

If you split the database, your users don't need to add any new forms. They just replace the old front end with a new front end. If you want to add new data to their backend, you can give them a single process that inserts all the new data for them It would just look like the way an install...

But didn't you say you don't have Access installed on the new PC. (#14) How can you be running an access database?

@BlueSpruce Congrats on your steady weight loss though. How long has it taken you to lose 50lbs? (y):)

It's funny. I don't know whether it's curbed my appetite or whether it's just reminding me to make better choices. I know if I'm dining out, I don't feel like I need to take multiple helpings of fries, and I don't hunger for things I used to like peanuts. However it's certainly making me need a...

How long. I am in my third month. I lost 9lbs, 1 pound, and maybe 4 pounds so far, so about a stone altogether. Only 2.5mg.

You mean you are getting errors on your old PC then? Has anything changed?

Is your new install of Access the same bitness as the old one? Changing from 32bit to 64bit inadvertently might cause an issue. 32bit used to be the default install, but now it's 64bit. You would most likely get error messages, but you never know. What error are you getting? Does it crash...

@DakotaRidge Given your layout in #16, I presume you have a different form for each expense type listed. If you add more expense types, presumably you have to re-design this form and create more forms for the new expense types. Really you need a single table of all the different expenditure...

Yes, but you don't need new tables and forms to add extra pieces of information (data, datum) to a person record. You add new fields to the person record, and redesign the person form to include that field. In some cases you might decide to model it in a different way, where the person's...

But a lot of this starts with analysing the data correctly, and constructing a well normalised data schema. It's not that an inexperienced Access user has a way to do something. It's more that he is sure that the shortcut he is using produces the correct result. The underlying issue is that...

Richard mentioned this in his video. Just as he clicked off it in the video, I noted that looked like the bottom of the popup form was on the centre, but I can now see that isn't the case. There is clearly some formula to work out the top, but it's not easy to know how Access does it.