Search results for query: *

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...

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..

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...

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, 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 all, This query has me..pulling my hair away. I want this query below to give me results from [PCB Incoming_Production Results] table where the error code in PCB Incoming_Production Results] are not in the [PCB Error Codes] table. but this gives me all possible combinations as my where...

Hello, Is there anyway i can make my front end such that the user cannot edit or delete some queries but he/she should be allowed to write, delete, edit, execute any new queries. note that when my front end opens the access interface is hidden the user cannot see the database window...just the...

Hi Does anyone know how to encrypt data? I have a password field for which i would like this ("******")to show when the user enters the password. Hopefully it won't be so involved. If anyone knows the code or could point me in the right direction it would be great. Thank you!

Hi, I need to setup some sought of security for my Database..the database can be viewed by anyone but only some users should be able to add, delete or edit a table or any record in the table. This is a backend Db and the front end resides in the same folder. i tried using the security control...

Hi, I have a query, works fine in Access but when i put it into VB it gives me a runtime error '3129' saying 'Invalid SQL statement; expected 'INSERT', 'DELETE', 'SELECT'..." :( Any idea how to fix this? Thanks for any help. Private Sub Weekly_Report_Click() Dim qdf As DAO.QueryDef Dim...

Hi, I am using the same form for two purposes. When the user clicks the 'Graph Report' button i want the 'GetGraphDatesStaub' form to open up but to disable the 'Weekly report' Button. This is what i have for the code in the 'Graph Report' button Private Sub Graph_percent_rejected_Click()...

Hello again, I have the following code...when i tried inserting to the first column it works splendidly..but when i try inserting to the second column (MfgPcb) in the same table ..it doesn't give me an error but when i check my table it doesn't insert into the column either.. Private Sub...

Hello, I am trying to basically run the qry below, but every time i run it , it gives me an error saying query must have atleast one destination field. So i went under queries and saw that the TempQry was blank.. I thought that the following code would automatically create a TempQry with the...

hey guys, I have a query called 'non duplicate data' and another query called 'Select common ones'.. 'Select common ones' has rows with ID numbers that are also present in 'non duplicate data' qry. what i want to is only show those rows from 'non duplicate data' qry that are not there in query...

hey guys, i have a report in access that shows a buncha graphs, it takes the information to be graphed from a table. An event in the form triggers the query which creates the table and which in turn creates the graphs in the reports. The query has a date parameter. so say the user enters dates...

Hey guys, Followin is my query that gives me the error saying "Query input must contain at least one table or query" for the StrSQL2. StrSQL qry works fine, does exactly what its supposed to do Private Sub Graph_it_Click() Dim StrSQL As String Dim StrSQL2 As String Dim qdf As QueryDef Dim...

Hey all! If in my table i have exactly 2 same rows then i would like to delete one of them. Luckily, if the rganum is the same for any 2 rows then the rest of the fields are exactly the same.. Here is the query i have so far.. DELETE * FROM TempTable AS t1 WHERE t1.rganum = (SELECT t2.rganum...

hey guys, I would like to create a loop where, if the user does't enter the right format i want to display a message showing the date format and would like to give user a chance to re-enter the dates..The code i wrote is as follows: Do MsgBox "Please enter the date format as MM/DD/YY, in...

Hey guys, So i have an action query 'A' that makes a table, this query 'A' selects columns from another query 'B', and the query 'B' asks user for dates that is [from shipment date] and [to shipment date]. I tried using the current db.execute cmd but it gives me an error saying saying "Run time...