Search results

Hey everyone. Right now I am trying to find a way to filter to a specific page on a form upon opening I have two forms, one for entering information and one for editing the information. When your on the "Search Info" page and you double click a record, that record is opened in the "Edit Info"...

Hey guys, Right now I have a command button on my main form that opens a browse box and lets the user browse for a document. Everything works fine, except if the user opens the browse box and hits cancel an error will pop up telling them that the path/file is invalid. As soon as they hit end...

Hey everyone, I had a question regarding option boxes. I have a form in my program used to edit information. I would like this form to be locked upon opening to ensure that the user doesnt change a value on one of the records by accident. At the top of the form I would like to have two option...

Hey everyone, got yet another question for you. I'm trying to set up a logistics system which assigns each product a locating number. There are three types of parts, one ranging from 0-10,000, one from 10,001-20,000, and lastly one ranging from 20,001-30,000. I plan on having my system set...

I have a weird one for you guys, I have a data entry form with probably around 400 controls. From my understanding Access has a 700+ capacity. More likely then not this is due to a large number of controls I have deleted that still have slots reserved for them in the background. Needless to say...

Hey guys, I am trying to set up a logistics system to store products. Currently there are three different product types. I would like one type to be numbered 0-10,000, the second 10,001 to 20,000, and the third 20,001 to 30,000. You guys pointed me in the right direction and told me I had...

Hey guys, I was wondering if you could help me out with a problem regarding a part locating system. We have three different types of parts and would like to group them by type. We would also like to give each part a number that could be used to locate them. Ideally we would like our...

Hey everyone, I have been writing a program for work and after about a month and a half I have everything working except one feature. I was wondering if it was possible to write an expression in the field of one of the columns of a query? I want to put something like this in the field box...

Hey everyone. I am having trouble getting my form to work properly after importing a picture. Currently I have a form with a listbox on it. I also have a command button that will open a report based on whatever row in the listbox is currently clicked. Recently I added an image frame, and...

Hey everyone, I have yet another access question. Right now i have a bunch of items entered into a table, each having about 50 columns of information describing them. What I would like to do is be able to print a report that will let me pick an item from a combo box (that works as a filter...

Hey everyone. I am trying to make a form that allows me to sort items by product type and compare an individual aspect of those products selected. Right now my report will print all of the products of one type, along with about 10 descriptive information boxes, but I would like to create a...

Hey everyone. I am writing a program which generates a report based off a combo box. The combo box is in the format show below Color Width Thickness Length Hardness Elasticity Item1 Item2 Item3 Item4 The database has around 50 items. Right now I am able to sort...

Hey everyone, I am currently using Access in order to filter through items in a large database using a combo box. Each item will have a hyperlink value stored in the combo box query that will open a more detailed powerpoint report. My question is, what would the code look like to have a...