Search results

my junk mail is bigger than that lol...

Show us the db is the first answer... and as said why under 1.5mb a db is as big as it takes to accomplish the task set we don't even know what you are tryng to do?

Sorry java is not my bag but if I knew what you were trying to do eg. why it must be java and why access might be able to help?

If your trying to do what I think your trying to do have a look here: http://www.access-programmers.co.uk/forums/showthread.php?t=167937 Good luck John :) EDIT: Or do what Bob says it probably makes more sense :D

Tried ctrl+break? EDIT: Attached is a properties setter can't remember which MVP site I download it from but was created by Bill Mosca and allows you to set start up properties of a DB :) So thanks Bill and whoever's site I downed from. good luck John

The most simple way is to set the value in the table you have created the form from, in the table select the field you don't want duplicates in then look in bottom left hand and select Indexed Yes (no duplicates) there are various other ways but that should do what you need. good luck John

an example: DoCmd.MoveSize 1440, 2400, 2000, 2000 (in the onclick event of your command button) Right, Down, Width, Height Mike375 is right regarding twips and using macro :)

Wheteher Javascript or not I would imagine that: if (TIOFORM.DropdownList1.value == "Waiting on BoH area") The ="Waiting on BoH area" is the text displayed but usually in dropdown lists the "actual" .value is the bound column of the source eg. 1= Test1, 2= Test2 etc.. May be wroung but look...

Solved my problem hrov Bob was right just hadn't got my syntax right.... :eek::o Forms!Form1!frmsubCOSHHSummary1.Form.Requery was missing a ! used . after form1 so not correct arrgggghhh. :D

Depends were you are putting it for your situation my problem is slightly different as the datachange is not in the main form but another subform on a different "Tab Page" and I am trying to force a requery on tab selection/change. EDIT: Got it put this in my OnExit event of subform syntax was...

Thank you likewise :) still working on it so may post back..... (if I don't go nuts first....)

I concur with Bob the ranges for dates would be to wide to compare any make of vehical side by side like that you would need to narrow down selection and display relavent details for that vehical in maybe a datasheet subform. Say on main form have comboboxes with make, model, and date range...

Have a look here theres a sample to: http://www.access-programmers.co.uk/forums/showthread.php?t=167898 isn't countries but is a cascading update of combo boxes so should be what you need. Good luck John

Been a long time since I used Access 97 but the date format is usually picked up from your windows regional settings are you sure they are set to Uk and not US also check the date format in the table you have created. Good luck John

Ok have looked around and its driving me nuts.... Have a main form with several tabs containing subforms, the last tab contains a summary of other tabs eg. built a query to bring together the required information which will later also be used on a report. Now can get the data to display no...

Shouldn't show anything if you are using an SQL query to populate the combobox and the default value is empty can't really say why it is greyed out without seeing an example of what you have done so far.... Good luck John

For a drop down value maybe: In the afterupdate If Me.combo.Value = "1" Then Me.Text1.Visible = True Me.Text2.Visible = True Me.Text3.Visible = True End If You would need this in form open event: Me.Text1.Visible = False...

As you have used the wizard to create buttons go to the onclick event of the button you are using and replace with: DoCmd.OpenForm stDocName, , , acFormAdd Unfortunately you have a few events un-named so don't know which one your using... good luck John PS. stDocName is the string set by the...

Copy your existing command button, right click on the new command button and select properties. Click the events tab and you should see (Event Procedure) in the OnClick line next to this you will see a button with 3 dots click that this takes you to the VB code for that event. In the code you...

Nice :) might borrow your idea and do that with my COSHH assessment db if I ever finish it.... John