Search results

OK Let me put this another way 2 forms loaded, myfrm and myfrm2 In myfrm2 I want to return a value into a text box using the text box Default value property. I tried the following and get the error message “Check the subquery’s syntax and enclose the subquery in parentheses” SELECT [myfield]...

Yes. The text box is on a different form from myfield and there a number of [ID] that will be the default value of textbox1, textbox2 etc.

It's 10:20pm in the UK and my headaches. I want to set a text box Default value to a field in a table. The way I would like it to work is :- = Forms!myform!myfield where Forms!myform!ID = 1 Now I know this does not work and it is probably just sorting out the sytax. I would like the forum...

No. Got me there Rich. Your not talking about print set up page properties are you? If so the set at almost zero.

I'm formatting a report that when printed would print on 4 A4 landscape pages. Well that's what I want. The normal design view goes to approx 55mm or so limiting me to at best 3 x A4 landscape. Any way round this? Thanks

Thanks Unc. Passing Newbury on way home from Portsmouth this afternoon. Would have bought you a pint for that tip if I had time. Cheers.

I have a form with tab pages which I can not change the tab order. When I bring up the Tab Order box no fields are displayed only a Custom Tab Order! Never seen this before. Question is how to get rid of this and be able to change tab orders. Thanks

Understood. Thanks

I understand what you are saying and this was my thinking. Probably easiest way may be to use Windows task scheduler. Trying to find a compilcated answer to a simple question! Thanks

I'm sure this must have been the subject of a thread before, but after an hour seaching my head aches. I'm running (Access 2000 on XP Prof) a sort of planning board. The week commencing dates change automatically, as per previous postings on here. I have a job run from a command button to then...

I'm using a simple command, similar to below, to transfere 40 cells from a spreadsheet in a table. DoCmd.TransferSpreadsheet acImport, 0, _ "mytable","C:\Data\mysheet.xls", False, "A1:A40" Can this be modified to import from an active spreadsheet without specifying the path? Ta

Thanks Pat. This is not a major issue. Just curious.

In the time-honoured fashion of reducing the size of the front end of a db I imported everything into a new db. The size reduced from 32mb to 17mb. Success. When I change anything, no matter how small, in the new db, it immediately increases in size back to 32mb. I always compact on exit. This...

Yes. Still no joy.

A common tip on this forum to reduce a db FE is to create a new db and import in from the original. Easy. Now I have done this and on navigating through the new db have no trouble when new. I then put in the start up form and close it. On start up again I get the following message. "Error...

Thanks mate. I can sleep easy now.

The increase is not worth worrying about, I'ts just that one of the main reasons in converting to MDE file is to reduce the file size and this has not been the case.

MBE approx 19.5mb mdb approx 19.0mb

I did C&R before converting and have done it also on MBE file. Still larger than the original mdb file.

I just converted a front end database into .MDE and the result is a database larger than the original? Is there something I'm missing here. XP Prof with Access 2000