Search results

Can a form be ordered by more than one field ? I have a form whos 'Order By' field is set to 'NEW_tblUsers.ROLE', this works fine but only sorts one column of data. Is there a way to cascade the sort order over more than one field ?

:o In the process of culling the database into a form worthy of posting I've discovered my error. Seems I had remembered to erase some arrays but forgotten to reset 2 variables half way through the code. This was having the "twilight" effect of altering my results depending on whether the...

My database has just started doing some very strange things - like ignoring its 'vba' code, but only occasionally. It's got me a bit stumped. The database is supposed to update a calculated value as users enter some data into various fields. Opening the database from new, the calculation is...

Thanks, however the files are still located outside of the database - the file locations are c:\ ... etc. My pdf is embedded in the database, in a table, as an OLEobject, which is where I want to pull up the file from.

Excellent, no rush - got plenty of more coding to do before the database is complete. :)

That would be fantastic if the pdf file I wanted was resident on somebodys PC, securely rooted in a network folder or otherwise external to MSAccess. As this database could end up going anywhere, the pdf is resident in the database. So I need to reference the location within MSAccess, which is...

What I want to do is 'click' a command button on a form and have a pdf file come up as an example of how the form should be completed. I have the form, the command button, and an empty vba routine. I have a table with the pdf file in it ( OLE object ). What I'm missing is the piece of code...

With any luck this is an attached example of the problem. I made some control and vba changes to one of the tab pages ( not the first one ) and true to form the problem came back. I then slimmed down the database for posting and the problem remained. Curiously when reloading the database from...

Thanks, I'll see what I can do ( I've never posted a database before ). In the meantime, I got into work this morning and took my database from home ( saved in Access 2002 ) loaded it onto my PC ( running Access 2000 ) and the problem has gone away. I've made no changes to the controls on the...

No subforms that I am aware of, and I wrote the form from scratch. It seems to be connected with the tab control somehow - but knowing access it will be something else. Oddly if I change the page order of the tab control the problem goes away, provided the first tab is not the one shown in the...

Tried dragging everything and could not find the table ? Very weird. So I've ended up rewriting the query. I think something was going wrong between work and home, using 2 versions of access.

Does anyone elses form display the footer twice, like this :- http://photo.ringo.com/262/262000018O183603375.jpg The form detail section contains a tab control. For some reason if I open the form from say a main menu, it double displays the form footer. It seems to do the same thing initially...

You know how normally in design view there would be a table at the bottom of the screen where you can drag your fields from the view above. Well, I have a query where this table view has disappeared ? I can edit the query in SQL view, the query works, just the table view is missing. Ever...

I seem to have tripped over the solution. My tables had no primary keys. Not only was this causing my form to fall over but also my queries. Now that I've defined the primary keys all seems to be peaceful again.

Ah ha. :) The new tables I created had no primary keys - didn't see the point of defining them at the time. Now that I have defined primary keys all seems to be stable again - at least I can update the fields in my query. Reading the small print, primary keys are mandatory to define...

The record source for a form can either be a table or a query right ? So in theory I should be able to design a form that populates more than one table at once, the common link being the query. So how come when I design a query to bring together 2 tables am I prevented from modifying the data...

I tried closing the form, this did what it was told however I then got left with the grey background of access. I guess making the form invisible would do the same thing. I am reaching the conclusion that tabs are not reliable.Not only do they not display properly but now it seems I can't...

When I move between forms they normally overlay one another so the current form fills the screen and any forms behind can not be seen. That was until one of my forms contained some tabs. Now only that part of the screen occupied by the tab is overlayed - makes for some very confusing images...

Thanks. I twigged to the cut and paste method ( rather than click and drag ), the routine you describe will save me a few hours.

I've got part way through designing a form and have now decided that it would look better if I used a tab control to display the data - it's a bit busy all on one page. Can I retrospectively add controls to a tab ? If I create new controls using the toolbox these automatically attach...