Search results

I had no idea it would become this involved. Thank you for the step by step explanation of this. I have attached another photo, let me know if it looks correct to you and where do I even begin on subforms. I looked into that a little, however it just wanted to pull the information from the...

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

I believe it is setup correclty, please view image.

I do have the junction tbl setup that way, however if I use a subform is it putting the information into the TblEquipment? And if that is the case then what is the purpose of the junction tbl? I've done some reading into what I want to get accomplished and from what I've read people are saying I...

Ok, If I wanted to issue some equipment to a person I would have to set it up like this: John Doe Phone 23 Radio 45 Gas Detector 15 I would have to have Main Form: First&Last name (2 different fields) TblEmployee SubForm Phone,Radio,GasDetector (3 different fields)TblEmployeeEquipment I...

No subform, I'm just trying to input everything in on my FrmTracking, source for the FrmTracking is split, I have half of it going to my TblEmployee and here is where I'm having a little trouble. Do I have the other half point to TblEmployeeEquipment or TblEquipment? Ideally what I want is to...

It didn't even occur to me to name it that way, but it does make sense to call i that way in the event that it does grow. I have called the aformentioned TblJunction TblEmployeeEquipment and have attached the DB yet again. I am running Access 2010, don't know if that might be a hurdle for you...

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

Mihail, I didn't realize that I needed to have the citation on the report for the code to look at but now makes perfect sense. Thank you so very very much for that. I absolutely agree with you on the report, what I was trying to do is to be able to view the full report and if the user felt...

Had to put it on a diet but I was able to attach it. I'm sure that you will be able to get it up and running, however I had to delete several other reports and tables to get it to where it is now. Forgot to say click on the "Citations By Area" on the switchboard. Input a range of dates and...

Name on the form was something that wasn't matching. Got a new error now, I don't know if it's a good or a bad thing. inherited this from someone who worked here a while back so I am learning as I go along, thank you for all the patience.

Pballdy, I went ahead with your advice and removed the space along with the # symbol. Still having issues. I am attaching what Access spits back to me. Had no idea it would become this complicated. It is highlighting the Me.Citation towards the end of the code. Sorry for being such a noob.

Mihail, To answer your question first, no the Citation # does not store dates it is purely a number. Also I've tried both of your suggestions and it still gives me the error Method or Data Member not found. Still highlights the Me.Citation Thanks for your help. Any other ideas?

I was able to get my report to pull whenever I used: DoCmd.OpenReport "Incident Report", acViewReport, , "Date = #" & Me.Date & "#" However whenever I have multiple records stored on the same date it pulls all of them at once, which is exaclty what the code is telling it to do. What I'm...

I think I found out what I was looking for. You definatly pointed me on the right path, acViewReport is what I was shooting for. Thanks for your help once again.

The acPreview argument? Is that some type of setting in the report itself, in the code? I'm really lost now. As you can probably tell I'm very new to VBA. Thanks for the patience.

I did notice an unexpected action with the following code: Private Sub Command29_Click() DoCmd.OpenReport "Incident Report", , , "Date = #" & Me.Date & "#" End Sub It prints out the record in the table, Kind of interesting. I will have to remember it for later.

What do I put in the where condition of the macro. It looks like what you have listed there is for VBA. Thanks PBaldy, I've tried putting the vba code you suggested. What is the control name? Is that the table the records are stored in?? Thanks once gaain.

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