Search results

@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.

Yes, I looked at the start, and posted the link as it seemed useful but then realised it was fixed now. I just didn't edit my post. (Edit. I have edited it now) It looks to me as if MS centered the bottom of the popup in the centre of the screen, as Richard was drawing those little rulers.

Video about autocentre. It seems to remember where the form was when you saved the design, I think. (Edit. Apparently it did misbehave but fixed now. See the video below)

Normally any purchase decision is to choose between buying a commercially available system, with attendant purchase and licensing costs, compared with building your own, probably more expensive to build, but less expensive to run. The commercial version ought to be fancier. As already mentioned...

This is an old thread. I remember this from the Access Cookbook "Open multiple instances of a form". (ie not a subform) The solution they offer is to do this multiple times Set frm = New Form_targetform (A real form in the database) Update the form caption. Then add the frm to a collection...

@MajP Incidentally I think this thread title is much better. "Faking it" gave the wrong impression I think. If anything the Access MVF is faking it. :D

I wanted a way to show multiple selections against a given record, which I think is similar to a MVF, although I didn't realise that, and I think I was building in A2003 which doesn't have MVFs. After I developed my solution, I realised it must be the same idea - but I think the benefit of...

I haven't read every post fully, but isn't a "popup" form automatically centred? I actually don't tend to use popup forms. I use standard forms, and where I want popup functionality I wait for the form to close before continuing (ie wait for the process to realise that the popup from is no...

With Access there is sometimes a real issue that the maximum size of a database is 2Gb. If you reach that the database will become unuseable, and possible unfixable. I have added a startup message in my larger databases to warn users that the size is getting large (system configurable value of...

@DakotaRidge Report width can be an issue. You may be able to get around that by generating a spreadsheet instead of a report. I am concerned that you use MVFs. I have never ever used one. It does not meet standard RDBS design criteria, and cannot be upsized to SQL server. If you really need a...

Do you have an active "timer" function. If that uses gettickcount, then it needs to use a 64bit version, not the 32bit. It's commented out here. Any other API functions need to be checked as well It's not really useful showing us code that ought to run. We need to see where the problem is...

I tend to use text for time only, with particular separators, and 24 hour clock. Check for minutes not exceeding 59 Eg, period or colon So 2.30 or 2:30 would be allowed but 2.75 not allowed.