Search results

The error wont stop occurring. Every time I try to send any number of components to my report it gives me the '3035' error

From what I have read I think I should increase the MaxLocksPerFile Registry. I have been looking at my VBA code but I am not sure where to place this code: DAO.DBEngine.SetOption dbMaxLocksPerFile, 1000000

I am currently working on a form and I have a list box in my form where I select components and then send the selected ones to a report. I started off just choosing around 3 components and it was working just fine. Then I decided to select all and I tried sending the components to a report but...

I am currently working on a project that was previously started by another individual. I am working in the form and trying to change to the code for the form but I am not sure what to change. As of right now in the form there is a combo box where you can choose from a list of systems, which is...

I guess to make it easier. How do you show the text values instead of the numerical place values from a field in a list box

I have a field in a table where it is a lookup is a combo box. So this makes the data type of the field a number when in reality it is a text. When I have this field show in a list box it shows the number instead of the text. Does anyone know how to fix that

I am trying to show another field on my list box that I have in my form. I am not sure how to do that though

The record source is the table of parts. I shouldn't have used the word relationship that was the wrong term. But has for linking. How am I supposed to link the forms when I choose to link it tells me to choose fields so I tried linking the ID field from the parts and the ID field from the...

I have made a field in the table "parts" that is a yes/no check box. I did this so that I can check/uncheck the parts I want in the subform. As for linking do you mean build a relationship? because I have tried that but it isn't working

Ok I did the company information on a form page but when I click to the next page on the form the check marks remain on the parts subform

Is there a way to create a form and inside the form you fill out company information in text boxes and then farther down the page there is a list of parts that you can choose from and then be able to check which parts you wants. Then be able to go back and add or remove parts you don't want?

That did not work

Well I can get it to turn to text but it only chooses the first row value not the value that I select from the combo box in the form

I have a combo box in my form where I have 4 options to choose from. Then when I send my form to my report it is appearing as a number. If anyone knows how to change that numerical value to the text value that I have in the combo box that would be great. This is what I have so far...

Thank you all but I figured it out

When I click the button that I have on my form it is giving me a pop up saying "Run-time error '3061' Too few parameters. Expected 1." So then I go to debug it and the highlighted line "Set rstCompNames = qdfCompNames.OpenRecordset." When I hover of it it says "rstCompNames = nothing." I am...

Would I create a relationship between all 3? And if so I'm not sure how to relate them

I do have tables. There is a table for customer info and table for items. I'm just wanting to be able fill out customer information and then select items from a list for that individual customer form. Then have all that information stored together so that I can go back and choose or delete an...

I am trying to export my access report to excel and keep the formatting from the report so that I can edit information in my excel spreadsheet.

I have two tabs and the first tab is a table where that information is saved and then my second tab is a subform which is made up of a combo box that pulls information from a table and then a list box that allows me to choose items and then sends the items that I selected to the updated query...