Search results

Hello all, I'm having a little trouble getting this accomplished. I can instruct access to print the report, however I just want to be able to view the report after I select a button. I will attach a picture so you can see what I have thus far. I do have an older version of this and it works...

Hello all, I've been having this problem and I can't seem to get any help on it. I've tried posting in the table and query forum, however I think it might be beyond that. Here is what I have: DBA (older DB) DBB (newer DB) I am wanting to take all the records in DBA tbl...

Hi everyone, Here is my problem that I am having: I have 2 db, DB A (older db) DB B (new db) What I have done is updated some functionality of the DB A, what I want to do is have a query that will take all the information in the table of DB B (new db) and put it all into DB A (older db)...

Hello all, I have a problem which it might be an easy fix. What I have is a database that I have done some tweaking on and in the meantime the original db has been in use which has added around 200 or so more records in the table. What I would like to do is to just update the db that I have...

Hello everyone, Ive been trying to add information into a table via a subform, however whenever I setup the subform on my main form, apparently the only thing I can do is select the information from the table Im trying to put information into and displaying that on my form. This is probably...

Hi all, I am very new to Subforms, here is what I have: TblEmployee(main table), TblEquipment and TbleEmployeeEquipment (junction table) what I would like to do is have my subform be able to store data that I input into it to TblEquipment. Is it the same as a regular form or is there a...

Hello everyone, I'm having some trouble getting my information that I input on my form to store in my correct table. I will attach my DB so you can take a look at what I have thus far. Here is what I am wanting to do: I have TblEmployee, TblEquipment and TblJunction and FrmTracking and...

Hello everyone, I'm probably missing something really simple here. I have a report that is a summary of multiple records in it. What I have next to the record on the report is a button. I have report that are labeled: rptIncident Summary rptIncident Report and a button labeled "open report"...

Hello everyone, I have absolutely no clue how VBA or Modules work. So here goes, I've got a report called "Incident Summary" and on my report I have a button called "Employee Injured" that I wish to pull up the entire record of the name input into my box and have it put into my report called...

I have a DB with TblInspector and TblViolation Data. Here is what I am having trouble with. On my form I have a combo box named Inspector and a text box named ARNumber. What I would like to have happen is anytime that I select John Doe from combo box Inspector it pulls his ARNumber from...

:mad:I have a form in which I would like to save some information into a table. This is the first time that I've dealt with multiple tables. I can get half of the form correct and everything is good there. I just can't get the other half of my form, which is looking to store information in a...

Hi everyone, I've been having this problem and I think it has something to do with my relationships between my tables. I will attach my DB so you can see what I mean. Open up the Tracking form to see what I mean. On my main form it gives me errors in my text boxes, I have, atleast to the best...

Sorry meant to put putting instead of pulling Here is my situation, I have a form that I want to bring up and then in that form have multiple multiple check box's that I can check and then based upon what I check I would like to be able to store that info in a separate table. My problem is...

I'm halfway there with this, In my macro where the "Where Condition" I would like to string together 3 things that are not equal to the text and then spit out everything else on my report. EX. [Location] not equal to "home", not equal to [work] etc. I know the not equal is <> how do I...

Simple question, I am wanting to display in a text box or on my report the total number or records in my database. Also I have some buttons that filter the results a little, I'm wanting to display the number after I hit the button(s). Would I just add the query to the end of each button I...

Hi everyone. Here is what I am wanting to do. I initially thought an input mask could accomplish this, but after some further reading on it what I am getting is only VBA can get it done. Here is what I am trying to figure out. I have taken over a DB where the original designer had a lot of...

I'm having trouble getting my form to be "blank" except for the labels upon loading. I've tried putting in some code "on load" but it doesn't clear everything. I haven't had this trouble on some of my other db's, the only difference here is it's a switchboard. I don't know if that matters...

I recently took over a DB that is based on switchboard form upon opening. Haven't done anythng with switchboards, my question is. On my report that I have open up I would like to filter between 4 conditions. Would it be best to setup buttons in the report after it is run, or have something...

Hello everyone, I feel like I am ice skating uphill here. I have something I'm working on and I need some advice to see if I'm doing it the correct way or if there is a better way. I will attach a copy so you can see what I'm trying to explain. I have 5 tables and 2 forms. The primary form...

I have an onchange event setup that filters employees by their employee numbers. It populates the text boxes in my form, howeve when I want to look up another employee by their respective employee number the old information is still in there and in order for me to look up someone else I have to...