Search results

well as per this post it says that open happens before load http://www.access-programmers.co.uk/forums/showthread.php?t=73628 as well I tried it and doesnt work my solution was to stop useing the filter altogether and just use the Me.OpenArgs and use a myarray = Split(Me.OpenArgs) into 3...

the form is a calander and I am useing the filter so that when the form is opened if the filter has data it goes to the current date if not then it goes to todays date for example If Not IsNull(Me.OpenArgs) Then If Me.Filter <> "" Then Me.ocxCalendar.Value = Me.Filter Else...

OK thats great if I wanted to clear it on open but I want to clear it on close so i tried Private Sub Form_Close(Cancel As Integer) On Error GoTo Form_Close_Err Me.Filter = "" Me.FilterOn = False Form_Close_Exit: Exit Sub Form_Close_Err: MsgBox Err.Number & " - " &...

I figured this would work but it does not Private Sub Form_Close() Me.Filter = "" End Sub as for some reason every so often the filter box contains data and screws up my form! and I have to go into edit and manually remove the filter and then its fine so how can I go about doing the above...

That worked perfectly For the life of me I just could not figure out the syntax!!!! :cool:

OK I am having trbl with this code Private Sub ocxCalendar_Click() mystring = Me.OpenArgs myarray = Split(mystring) 'myarray(0) 'myarray(1) [Forms]!["myarray(1)"]![txtDate].Value = Me.ocxCalendar.Value DoCmd.Close End Sub keeps saying unable to find form myarray(1) even though when...

Is there a way of shortening this code Private Sub Command1_Click() Does something in here doesnt really matter dont have the code as its at work End Sub Private Sub Command2_Click() Does something in here doesnt really matter dont have the code as its at work End Sub Private Sub...

I guess what I mean is that it works well in excell word and all the programs that have scroll bars on the side that are not created by the user IE forms in there I can see it being a pain however In my search I had found info on disabling the scroll wheel do a search in the vb help as they have...

Why is it in the year 2004!!!! Why cant Microsoft do anything right lol what I mean is why is it we have to install third party software to make the scroll wheel working in the Microsoft Visual Basic Editor Especially when it works great in the rest of the Office programs??? is there a reason...

that is true but I have hidden objects viewable while editing I guess that would work is there another way? maybe in vb some sort of criteria i can check on?

I was wondering how do I stop a form from being opened in the database window so that it can only be opened from a button in other forms?

okcool! :)

Lol Figures, I was wondering what the difference was! Thankyou P.S. I couldnt find it in the access help thing Straight from vba help! where is that?

What is the difference? :confused:

Ok, I dont understand the Query ones? can someone explain how they work also is there a fast way to update all my forms and querys after updateing the tables with tbl in the front?

I was wondering if this is still the starndard naming convention http://www.mvps.org/access/general/gen0012.htm and if so then to what this is saying all table names should have a tbl infront of them! I am also aware of the reserved words list however if you follow the Standard naming...

Thats cool Thanks! I will try it tonight :cool:

I wish you luck I hear that its really good I have not had a chance to delve into it myself either as of yet :) but that will be your best bet :cool:

Can you maybe upload a screenshot of what you are looking at as I am not able to find the same property I see property of close button and a choice of yes or no??? :confused:

Honestly your best bet is to either learn asp or php and create the webpages from scratch as the wizard does the trick but as you have noticed anything beyond your basic form it is not able to convert! I know I have tried :D