Search results

Hi, I wasnt quite able to find an answer anywhere yet for what i am looking to do, so here it goes... I have a parameter query set up to run a report which is simply asking for an employee id. So in the query I have [Enter Employee ID] in the criteria section for the EmployeeID field. When i...

Hi, I'm not very familiar with using macros and I am wondering which action i need to choose to do the following: I have a combobox and a listbox on my form. The combobox uses a macro to find a record on my form but i need to add another action to that macro. I want to set my list box to...

Thanks for the info Ridders, Hopefully i can find a solution somewhere within the links youve provided. I appreciate the response! Brian

I am using Windows 10 ver. 1803 .

Hi- I am running Access 2013 with a Front End and Back end. The four people using the front end each have their own separate file on their c: drive. The back end with the tables is on a shared network drive d: Recently the back end seems to crash out of nowhere - Ill be entering information...

Hi- The rowsource of my combo is the following: (i used the wizard to create it to select records on my form) SELECT tblStandardCost.ProductNum AS [Product#], tblStandardCost.Category, tblStandardCost.Description, tblStandardCost.CustNum AS [Customer#] FROM tblStandardCost ORDER BY...

Hello, I have a form with a combobox that selects records. Is there a way to filter the combobox based on the form filter? For example: My form holds a recordset of 100 records, and without any filter applied, my combobox also holds 100 choices...... I want my combobox to reflect the curent...

Hi, After my database got corrupted at one point and after running compact and repair, Access automatically created a duplicate of every table in my database with a 1 next to the name. Example- if i have tblClients, then i also have tblClients1 . And if i add records to tblClients they are...

Hello, I have a strange problem that i cant figure out - please help!!!:banghead: I have a database with numerous forms all of which function normally, except one my my forms which recently does not display the records indicator in the lower left corner where it should say Record 1 of 6504 for...

Hi, Would someone please help me?! im not sure what im doing wrong here. I cant get my listbox to filter to a specific set of records based on the query criteria for the listbox. I have a list box on a subform of my main form. here is the criteria i have in the [acct] field of the rowsource...

Thanks Ranman, but for some reason If isNull didn't work for me. I ended up using .listcount = 1 and it did the trick. BJF

Hi All, I have a combobox called BillTo, and after a selection is made, another combobox named ShipTo is requeried for corresponding records. I made the following code, but it does not do what i want. I am looking to populate bound Ship to fields with the info in the BillTo combobox upon...

Hi Everyone! I am not sure how to append records to a table from my unmatched query. I have run an unmatched query on my tblClients and tblShipToForClients. The result is that i get 4138 records from tblClients without a match in tblShipToForClients. How do i get those 4138 records added to...

you need to get the clientID out of the header and put it on the form. you can put it anywhere on the first tab, then make visible set to no if you dont need to see it.

Hello, I have a form in which i put a listbox that finds records when selected, as well as a search box which locates records. Both work fine, but i am trying to figure if theres any way to make the listbox show or scroll to the record that im on if i use the search box to get to the record...

Hi, I have little experience using the macros in access. Would someone be able to direct me on how to make my macro work! below i attached a screenshot of what ive got so far, and the filter is working fine, only i cant get the messagebox to work. i named the applyfilter 'FindRecord' but that...

the form is used to enter a customer name, the form filters to a recordset of open orders with that customer, and then a report can be printed by pressing a button. i need to be able to edit the notes field though before printing, so i d like to see a list of open orders in datasheet view so i...

Hi, I need to make a subform on my main form show 2 fields from the filtered recordset of the main form. right now i just have the query set to mimic where the main form record is. it is: SELECT qryOpenOrdersByCustomer.SO, qryOpenOrdersByCustomer.Notes2 FROM qryOpenOrdersByCustomer; what i...

thanks sneuberg for the advice, i changed the primary key to ID (single key) and it fixed everything. im not sure why i did the dual key initially; i created that table a few years back and not sure my reasoning behind it. anyway, thanks for responding . BJF

Hello, i am having a problem with a query i built based on three tables. I have found the reason why my query is uneditable but dont know how to correct this so i can edit one field in particular. the query is built on these tables: tblSalesOrders - primary key is 'So' tblClients - primary...