Search results

I am importing a text file into an Access table from an OnBase system. The text file is the result of an inspection. The text file has 19 fields. One field out of those 19 is an inspection code field and unfortunately, it has varying numbers of inspection codes in that field. Each code is 3...

I have a database with security setup and either by user or by group I would like to inhibit the navigation pane. Like, for anyone in the Admins group I would like the the navigation pane to be available but for anyone in the read only group I would like the navigation pane to be inhibited. I...

I have an access program that is in 43 remote locations. I need to update a form to change some leagle jargon in a disclaimer on that program. I need to somehow send this form to these 43 sites and update the database. Is there an easy way to accomplish this function? The users of this...

I need a bit of help with lookup code The following works well, it brings up a list box by application number Private Sub Search__AfterUpdate() Dim rs As Object Set rs = Me.RecordsetClone rs.FindFirst "[appl_no] = '" & Me![search#] & "'" Me.Bookmark = rs.Bookmark End Sub The problem is say...

I have a report that is based on a query. The report shows total applications per county, total records per county and total dollars. The problem is that if I want to show only the total application per county I have to use a separate query and group by the app number. This works beatifully...

I am working on a database to track aerial applicators as they move from company to company in the course of a growing season. My main table (company table) and form has company information and the subform has the pilot information (pilot table). As the pilots changes companies as they move...

I need to show a total in a report (lets call in rptA) footer for applications that have been received. The problem is there can be multiple records per application in this program. So, =count([app_no]) in the report footer gives me more apps(1001) then have been received (840). I created a...

I am a long time nubie and am having a problem with a nested subform. Really, all I want to do is tab from a field on the main form to a field in a subform that is inside a subform. Lets say that we have a main form then subform A and subform B is a subform of subform A. I want to tab...

I figure there is a simple answer to this but I am just not seeing it. Need some help with some fields that should be calculating on a subform. For example, I have =nz([field1])+nz([field2]) in the control source of field3. When I tab through and enter, maybe 5 in field1 and 6 in field2 then...

I have a location table (address, city, state, zip and phone #) that has a couple thousand records and lots of duplication. The table was originally entered (without much thought) in approach so I am converting it to Access. I want to break this table down to unique records with no duplication...

I am being asked to modify a old program for a new similar function. In the blue heading bar above the tool bars there is a name (ECB License) for the database. I need to modify this name to the new name (wheat license). Thanks for your help. GG

I have a query called VOLTEST that is not bound to the form. VOLTEST sums a field in a table from a subform. When the input is finished in the subform and control goes back to the main form, I want the total from the VOLTEST to show in a field on the form that is not a tab stop. Basically, this...

I want to run a query automatically in the gotfocus event of a field within a form. Prior to the gotfocus, a value is entered in an unbound text box on the form and I want to use that value for the maximum value in the parameters. I will set the minimum to zero. My code errors in the where, it...

I have a statistical program and the user constantly use the form to check calculations and get out without saving a record. In order to allow this with out writing to the table I used unbound fields and an accept and close command buttons. This worked well until I added a subform to one of...

I need to set the criteria to filter out all records but one for a single field in a query. The table has all the teachers for each elementary school in the state of Nebraska. I want to send a letter to each school not each teacher. School name is a field in the table. Is there a criteria I can...

I need to pull data from a cell in an excel spreadsheet and put it in a specific field of a record in an access table. The excel spreadsheet is updated several times daily by an outside source. My user cuts and pastes the value from the excel to his access table whenever he needs to run the...

I receive data in 10 separate excel spreads on 10 different balances. In the spreadsheets there are 100s of calcs that go into the standard deviation. I need the standard deviation(sd) from each of these spreadsheets in a balance table. Currently, we manually input the sd for each balance. I...

I have an older program that has a lot of entry forms. All of the forms have several entry fields. A slightly visually impaired person is being asked to do entry in this program and is having problems with size of the font used in the entry fields (too small and not dark enough). Is there a...

I have a problem with program that tracks inspections. I want to open a form in edit mode and have it automatically go to a specific inspection number (insp_num, which is a unique text field in the table). I want the form to populate with the data from the record that coresponds to the...

In the on current event of a form (Form_B) I am pulling data from another form (Form_A). The problem is that sometimes I will need to go to form_B when form_A is not open. When that happens form_B will error out. I need to figure out some form of an if statement to bypass the code that pulls...