Search results

I'm working on a access application and would like the best way to achieve what I'm trying to do. I have 3 tables that have different types of data so I want to have 3 radio buttons on my main form and an ID search textbox and search button. The subform will be populated with the form based...

Hello, I have a combo box that when changed I want to update a date column in one of my tables. The issue I'm running into is if a user selects the same value that was already selected the event fires and updates the date. I only want an update when the value completely changes. I've tried...

I have a make table query where one of the columns is left(Text,7) as Text1 Now when I view the design of the table it says the column is 255 characters long even though it is only 7 characters. Is there a way to do this through my query? I can't create the table before hand either. Thank...

Hello, I'm having an issue with tabbing in my subform. I have 20 fields per record. I have the "Tab Stop" Set to "yes" for 17 of the 20 fields. So only 3 combo boxes are tabbed too. They are the only editable fields on the record. So after record one is tabbed through it goes to record 2...

Hello, I would like know the best way to do the following scenario: form1 is tied to table1. I have a button on form1 that when pushed a modal form will pop up with form2 which is tied to table2. Now within the relationships table1 is one to one with table2. My question is how to add a new...

I have two tables called Tab1 with ID and Name Tab2 with ID, value, text Within the table def I made both Id's the primary keys. I went to the table relationships and dragged from Tab1 ID field to Tab2 ID field. Now what I want to do is have a subform from TAB1 and a subform for TAB2. When I...

I have a frame with two radio buttons. When the wizard created them I said no to have any defaults. Both are now gray when the form loads. How can I get both to be white with nothing selected? In my form open event I set the default to each option to false and nothing changed. Thank You for...

I have a main form with a subform within a subform. Form C is within Form B and Form B is within Form A Form B is based on a record source that I set using VBA when the user selects certain drop downs and hits search on Form A. Form B has 2 Seperate keys that make it unique (recordnum and ID)...

I was wondering if there was a way for a message box to display a text box value with the input mask? I have a text box that displays 000-0000-0XX0 but when I message box this value it shows up as 00000000XX0. I thought this was something simple I haven't been able to find anything on it...

Hello everyone, My question is about front end/back end databases. If I keep my front end on a shared network drive and allow multiple users(10-15) open the front end from this network drive will this cause me any issues or will access open an independent copy of the front end for each person...

I have a form that I want to set the recordsource to a query with a parameter passed into it. The parameter is derived on the onload of the form but i'm not sure how to set the forms recordsource to the query and the parameter? What i'm doing is taking the users windows login username and...

Hello, I'm trying to find the first space in every row in a specific column Col1 ------ BOB JOE FRANK DAVE WILLIAM I need my result set to be BOB DAVE WILLIAM I've tried Select instrrev(COL1, " ") From Table1 I keep getting zero back. Once I get the position of the first space then I can do...

I have a combo box I have to populate based on a query. I'm also doing an import within my app and if I hard code my query within my drop down I get an error during my import about it being used by someone else. My import effects the table that is used in my drop down. So i'm trying to use the...

I would like to know what property stops the drop down from being edited at all. I have only in list set to yes but the user can still type in the drop down. I don't want them to be able to do that.

I have many date fields that I want to validate a range for. I created this function to pass in the text so that it will verify the date and then display a message if it is out of range then cancel the change so it isn't committed. Private Sub txtInDate_BeforeUpdate(Cancel As Integer)...

I have an access front end that compacts and repairs after each time it closes. What it is doing is setting the modified date to all of the forms to the system time and date when the front end is closed. This is the link from Microsoft but it doesn't have any resolution. Does anyone know how...

I have two db's a front end and a back end db. One of my users recently got this error "Could not update currently locked" Access "3218". I have a form tied to a table. She changed a drop down that puts an ID in the table row and the error occurred. This has never happend before and the...

I need to execute an append query from my vba code but I have to pass in a parameter. I can't set the parameter equal to a form control. I have to actually pass in a value. I don't want to use a querydef because I don't have any result sets. Any help would be great. Thanks

I'm trying to create a find that will search through all my forms and let me know where a specific control is. I have it working if the forms are open but I can't open every form to run the find. Does anyone know of a way I can search all the controls on the forms to find where a specific...

I would like to know if anyone knows if I can create a query that will give me a count of the number of queries within my access DB? Thank You