Search results for query: *

Thanks jadams0173. That worked!

Hey guys, Following is my code to disable the shft key. In the past it has worked on other forms but just doesn't want to work on the back end Db. Here is the code This is how i call it in VB: Private Sub Disable_Click() Const DB_Boolean As Long = 0 ChangeProperty "AllowBypassKey", 0, False...

actually on a second thought..thats works fine...i didn't even have to write the code you gave. Just entering the format for text box under properties as mm/dd/yy..worked fine... thanks.

Thanks RivThead. it worked.

Hey, I have a combo box that i would like to be read-only. That is the user should be able to choose a name from the combo box list but not be able to write any of their own. Thanks..

if i put the code under the After Update column then my error messege shows up only if a user initiates an event like hit the 'cancel' button or hit the 'okay' button..however the access error comes up if i move to the next textbox , and i think thats because i specified the format in the...

Hey guys, As the program is now I have the shift key disabled and the access interface hidden and the only way a user can get into the design mode or actual coding is if the user has the password. As of now if the user knows the password i enable the shift key and automatically close the...

hey guys, How can i set the format of my date to mm/dd/yy in the properties of my text box itself...i have a start date box and an end date box. and if the user doesn't enter the right format in say the start box then i would want an error to pop up before the user moved to the end date..To do...

thxs..this problem is fixed.

Thank you PH!....who woulda thought that such a simple solution could have fixed such an annoying problem.:)..thanks..

double checked the spelling. Thats correct. I am adding my code as well, just incase i am missing something obvious, The qry in the bold is the one thats giving me the IMHO box..i need the first 2 queries inorder to run the 3rd qry... Private Sub NoFailedPCBByET() Dim qdf As DAO.QueryDef Dim...

I am not using a parameter prompt.. All my queries are in the VB code and i am using a form for the user to enter whatever parametes i need. The problem is that in my code i have a null column..and there are reasons for which i cannot remove the null column...this column does not exist in the...

hey guys, in my vb code i am running a query that has a null column...when i use the front end to run the query it shows a box saying 'Enter parameter value'. The null col cannot be removed and is important for the next step of this qry... is there anyway i can disable this dialog box from...

hey john, Thanks so much for all the help. This part of the program works. I still do get the "enter parameter value" dialog box for col3 that access automatically pops up everytime the query is run. Any idea how i disable this pop-up dialog box in my VB code?? thanks!!

okay my bad. i found my mistake. Entered different names for the null column in the qry

Hey, actually a column3 needs to be added to QRY B, i think i mislabeled the number of columns in my description the first time. But anywho i did that and when i execute the qry it output the parameter box and asks me for the value of col3. this is what i entered in the queries under Db window...

Thanks John. what is the sql code to add a column? also would i have to output the information into a table or something??

hey dhookom thanks...i might actually be able to use this in my access app. How do i include just my tables in the zstblQBFSource??

Hey, Okay, i have qry A and qry B..and i want qry C that would do qry A union qry B. The problem is that.. qry A selects 4 cols from tables and qry B select only 3 cols from tables. Both qry A and qry B are aggregate queries. The union of these two queries would have worked great if qry B had...

hey thanks fneily. It worked after i specified the one-to-many relationship between the tables.