Search results

Sorry if this seems like an obvious question, I have a pretty straightforward idea of what I need to do, I just can't figure out how to do it! I think it may need the dlookup function but I never can get that to work properly! I have a form based on a table. One field, Max Passes and another...

I am trying to create a form that will search my table for any records where a specified word appears in a specified field. Both searchable fields are memo fields, and can have lots of words in. So what I want is for the user to be able to select field1 from a combo box, then type in "word"...

I have a form with a few buttons, and a subtable that is linked to my main table, and displays a whole lot of data in table view. What I need is to be able to print the table in the same format. Is this possible? If it is possible at all to print a table in table format, then that would be...

Hi, I have a date field called bookedindate, another field called supplier, and another called bookedoutdate. What I want to happen is, if a certain supplier is chosen, the bookedoutdate automatically changes to 3 days after the bookedindate. I'm okay with most of the code, it's just how to do...

I have a piece of code that opens up a form and displays the record by an ID the user specifies in a text box. If the box is empty and they press the button, it errors and opens the VBA code. Obviously this is not something I want the user to see. Firstly I tried an if statement so if the text...

Hi, I've searched through previous dlookup threads, but nothing seems to work. I have the following code: If IsNull(DLookup("[Type of QC 2]", "Priorities", [ID] = tempID)) And IsNull(DLookup("[Type of QC 3]", "Priorities", [ID] = tempID)) Then Forms.frmQCReport.txtQCID = 1 End If...

I want to have a button that will create a new record in my table, and populate a couple of the fields with certain data. Is there a way I can do this using vba?

I have a form in datasheet view. The user sees all the records laid out. there is then a text box, where they will type the ID of the record they want to work with, and press one of four buttons that link to different forms. What i need is for the form to open up on the record that the user...

Hi. I hope somebody can help me with this... I'm not a VBA expert, just self taught in things I need to know. I have a form with several combo boxes, and a subform below. Every combo box represents a field on my main table, allowing people to search by chosen criteria. I've written code that...

I've got a mental blank, I want one of those things that is a text box with little up and down arrows on the right so you can choose a number. What's it called?

Apologies if this has been covered lots before, I searched and couldn't find anything. I am very new to this side of Access so simple instructions would be appreciated. I'll try to explain it as clearly as I can also. I have a table with a bunch of fields detailing a job going through our...

Hi I have a form that is basically an autoform for inputting into my main table. I have one combobox that has customers in it.. let's call them a b and c. Further down is another field, called Reference. Each customer can have certain references. I want the reference field to be a combobox...

I have one form for edit details to a record. I want users to get to this form from another form, where they type the ID into txtID, press the button, and it opens the form on that record, with all fields filled in relevantly. Is this possible? If so, how? Thanks in advance!

I've made the form below, with a sub form in it to show the table below the text boxes. What I'd like, is for the user to be able to select a record on the table (preferably just by clicking on it) and the text boxes to automatically populate with the relevent data. Is there a way to do this?

I have a form that I created using autoform from my main table. The form is just for the user to enter a new record. But when opening the form, how do I get the fields to be blank and on a new record by default, rather than starting on the first record with the fields already populated? And...

I have a macro, OpenReport, that runs when I hit a button. But every time, it tries to print the report. I don't want to print it, I just want to view it. Any ideas?

I have a query that draws a product ID, some information about the product, and then a number of faults. The faults all come under one field name though: "Fault". (Funny that). Is there a way to include each fault in my report? When I choose "Fault" from the field list box, it just shows me the...

I have a query drawing information from two tables. The first table has information about a product, and the second table holds all the faults found per product. So any one product can have anything from 1-14 faults. I have created a report from the query, but the Fault item that I put on it...

I'm not sure if I'm being really stupid here or not, but I'm rather stuck. I have a report that is created from a query. One of the fields is "Quantity" which is a number between 1 and 500,000. I have a custom label on the form which I want to display a certain number depending on the Quantity...