Search results

Hmm I didn have one more question. If the code is essentially telling the report which field list values to display, how does it know how to format the form? How does it know where to place each of the boxes? Was just kind of curious.

Haha well i'll see if I can figure out a way to pull it. In the mean time ill try to play around with it a little and i'll let you know if I me and my limited access abilities can figure it out :P

But with the SQL string that we set up, should it pull those two values we have entered in? Ideally, should the report be printing those two values we have entered in addition to whatever field we selected in the combo box?

Right now i have the report blank, and I have the query set as the source. Let me see if I can understand the code. That might help me figure out what im doing wrong. Private Sub Command154_Click() Dim strSQL As String Dim qdf As DAO.QueryDef Dim strOriginalSQL As String Selects the...

Nope, kept that one as just one word. Should the report im using be blank besides setting the query on it?

Alright so I managed to get the command button to run error free, but it just opens a blank report. Do i have to code the report page in any way?

Haha well I think i'm getting close. Except now when I try to run it I get the error Syntax error (missing operator) in query expression 'DepartmentFROM Basic Program InfoORDER BY Product'

Private Sub Command154_Click() Dim strSQL As String Dim qdf As DAO.QueryDef Dim strOriginalSQL As String strSQL = "Select Product, PartNumber, " & Me.VariableBox & _ "FROM Basic Program Info" & _ "ORDER BY Product" Set qdf = CurrentDb.QueryDefs("Variable Report")...

Hmm so if i try to put an expression in the field box of the query, the table box will clear itself out. At this point im guessing there is really no way to implement a feature like this :/

I'm not by my main computer now to get a screenshot, but let me try to explain it a little better. So I have a main table with about 50 different variables on it to describe a product. I want to generate a report that prints a list of all the products. The report will display the product...

Ah sorry, just put that . to end the sentence, if that makes sense lol. I have also tried [Basic Program Info].Forms![Customer Info Search].VariableBox But didnt have any luck. I am trying to place these in the field box. If i type Part Number in the field box, it will look for the field...

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

The other tables of information are just more descriptive information such as height, length, width. It would look messy to put 100 columns of information in one report, so instead we would like to always have the original 9 columns (the most important information) and then have one column that...

Sorry i'm doing a bad job of explaining. So I have a form with a list box in the center of it. The row source of this list box is a search query. There are about 50 items (50 rows) in the list box. Each item is described using 9 columns that display information such as product type, part number...

I was actually able to figure out the cascading combo box (thanks to these forums) but what I was trying to do was a little different. Right now I have a combo box that has 9 columns with stuff like product type, engine type, ect. I would like to have a combo box that allows the user to pick a...

Awesome, that did the trick. Thanks Pbaldy, I appreciate it. I have one last question. How would make that same combo box the row source in a search query? I want to make one column in a seperate combo box change depending on the table selected in the box.

I actually wound up scrapping the first idea as it was too messy. Is there any way I could use a drop down box to select a table on the form, and then print the contents of that table on the report? What would the code look like?

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