Search results

8 pools - Leisure Pool, Lap Pool, Indoor Pool, Hydrotherapy Pool, Indoor Spa, Outdoor Spa, Slide Pool and Hot Pool I have been mucking about with Docmd.goto without success. I will try again setting focus to the form hard code and see if it works. No that didn't work. the record stubbornly...

One property i manage has four. A property I used to manage in NZ had 8. Manually the user clicks on the pool to enter the relevant data on the main form.

This is difficult to describe, so please bear with me. I have a main form, with a subform showing details of swimming pools installed at a property. To add a new pool I make the main form invisible and load the new pool details via a class to the pool table. I then return focus to the...

This has helped a bit. I hjad to do the following before I started to only get double the load time. Turn all tables subdatasheets to [None] Turn off Autoname Correct Decompile the frontend I am using and need to use pessimestic recordlocks.

I'm running XP Pro (peer to peer). I wonder if it is an XP thing???

What version Access are you running? I have not had this problem before and suspect it may be a 2002 problem.

When I split my backend tables off from my application and use the link manager to link them my application is taking a severe performance hit. What do I do from here, should I look at an SQL backend or quite what?

See attached

Try Mouse Wheel Event in XP Help file

The forms recordsource is updated in the Makequery Sub

Maybe I am going blind or stoopid (more stoopid) or both but I can’t see what is happening here. I have a form which displays historic data for a data entry form. Previously it has been a static display displaying all records regardless of what we are testing for. However, this requires the...

Thank you. That solved that problem. So simple just one of the combinations I have never used.

At this point in time that would be correct. Although it is a query not a table.

I have a form which is balnk to start up. On this form I have various command buttons. I thought to prevent errors I would enable and disable according to the record on the form. On start up the form has no record. So when I code if Me.ID>0 then I get an error saying Me.ID has no value. I...

Apparently we are further away than Honolulu. If you lived here you'd believe it. WA=Western Australia=Wait Awhile. I have a few unbound forms in the system. I guess if I was doing this again I would consider the unbound approach. A work around I have found to tons of coding is a...

To say this issue is difficult to describe is an understatement. To explain how the form and subforms work is even more difficult, but I will try. I have a form, which is resident to a master subform. The master subform contains 5 other subforms. I tired the traditional approach of querying...

Page setup is fixed in XP. I think the decision to upgrade is about features. Given that 2003 is supposed to be launched in June why not wait until the inevitable special offer of buy this upgrade and receive the next one for $50 hits the street.

This is fairly complex but I will try and explain the issues. My report is populated with unknown values right through. The only known values are in the report header after that the entire report is populated by unknown values. What this means in practice is that I have a form which is...

I went with Wise and Sagekey. I have been pretty happy with the results. I did have to phone Canada for tech support a few times as I have found their email support a bit vague.

Make a select query to return the results you want. Then use the auto form tool to build a new form.