Search results

Sorry i was not sure of the right place as it involves code and forms. Any way please click the link below http://www.access-programmers.co.uk/forums/showthread.php?t=121221

As you can see the code matches the report name. So am not sure whats wrong. as it works then it doesnt. Unless I just need tot turn off the error messege in this case ???

This is the error messege

I have 3 queries and use 3 different forms as search criteria. The forms produce a query or a report based on the selection in combo box. (please see attachment) The query button works 100% of the time yet the report button although works some times gives the following error messege. 'Runtime...

I hate the Access 2000 buttons I think there boring and dull. I would love to customize them to make them more windows XP with like a metallic colour etc. Is there a template website or is this not doable

Private Sub Form_Open(Cancel As Integer) Me.Detail.Height = 1440 * 3 Me.Width = 1440 * 3 DoCmd.SelectObject acForm, Me.Name DoCmd.RunCommand acCmdSizeToFitForm End Sub just tried this one on both forms. both forms opened at different sizes and different postions. :confused:

I have searched this problem and seen many results but nothing which works for me. My problem is simply how to size every form the same and have them all the same screen position. Sounds simple but will not work for me at all. First I tried dragging the form in desgin view to set the sizes...

Mine wont work, could you please check and see where am going wrong?

BUMP BUMP BUMP this is what I have been trying to do allllllllllllll day, ive been going round the world and bend. Thank you so much. Lets hope I can look at your coding and combo boxes to see how you related everything

okay thats great thanks

Hi Instead of making and saving a 100 queries and making a 100 buttons for each query. I would love 1 button so when you lick it, a window would appear. In the window you would type in your query "criteria" which would then display the query with that criteria. I know I would first have to...

thank you so much. haha I am not the most effcient user is Access so could you point me to where i group by SOP_ID

Hi I have created a report and on the report there is repeating information. (please see attached) as you can see it says LIMS055 twice, LIMS054 twice etc. it is correct that there are two users in this department that need LIMS055 etc. However it would look more professional if it just...

thats brilliant I found that easy. thanks However althought I have both forms the same size main menu = height:11cm width:23cm (no header or footer) user form = heigh: 11cm width: 23cm (header:0 footer:0) it still does not go the same size. please see attachment.

haha yes i would like to avoid coding but I also want to improve my coding skills. Sadly I never got to test your method but I think it would have had a simliar process. thanks

Brilliant, works a charm. I think it will also be a smoother action when I have all the forms algined and sized the same. Thank you for this and your tips. great forum every one

hi sorry you must have replied while I was replying. So in this case the form would open and then the other would close. Therefore giving the impression of the form opening much faster. Yes thats what i hoped for. Il try this and let you know.

Hi thank you for the fast replies I will try explain better. this is what I hope to achieve You open the database and the main menu appears. you then click a button. the main menu then gives the impression that it "turns into" the selected form. I never want two forms open at the same time...

I found the the properites box on the recordselectors. I can edit the width and set the auto centre to yes but i still cant do the length, any help?

Hi I would like to produce navigation buttons so that when I click for example "back" button I can naviagte from Form1 to the main menu. I have currently experimented with some code ( am not a programmer ) and edited a Open Form button to include this code "doCmd.Close. The code in total looks...