Search results

Debugged cboBOMDescription and Me.Parent![Txtreservationid] and they are returning the correct numbers

I actually had to do this to get it to return the result: Dim test As Integer test = DCount("*", "tblReservation_Details", "[BOMNumber] = '" & Me.cboBOMDescription & "' AND [ReservationID] = & Me.Parent![TxtReservationID]") <> 0 Debug.Print test

Figured out the debugging and discovered that dcount is returning a 0 no matter what is selected in the combo. Will have to do some digging... By the way, in my tblReservation_Details I have ReservationID and BOMNumber set as primary keys so i avoid allowing duplicates. Only problem is if I...

Thanks pr2! It seems like its almost working. I am getting the message box everytime I try to add an item though. Is there a way to debug the dcount in the immediate window?

I have a form and subform. Reservations, and Reservation_Details. Reservation details is where I add my items to be reserved. I want to pop up a message and undo an entry if it already exists in the subform. I am using this code: 'Custom error message if you are creating duplicates Dim...

Ya, I think for the most part I'm good. Its just that when you are brand new to access you can easily overlook small things like this that turn into big problems. Im sure there are some other flaws I just haven't found yet!

I looked at that data model you sent me in the second post and that is pretty much exactly how I do it. I think the way to fix it is to move the dates requested to the item being reserved, that way I can have different return dates for each individual item rather than the entire reservation...

How do I log in?

When I started this database application I was a beginner, so the concept of a data model was lost on me and still sort of is!

I have an equipment table aswell as a bill of material table. A collection of equipment is a BOM, and the BOM's go on the reservations. An example of a BOM would be something like a laser scanner that someone would borrow for a period of time. If thats the only thing they reserved, and they...

Hello, I have a reservation system set up that includes a parent table with a child table. The parent table contains all of the information about the reservation, such as company name, date out, date in, contact name ect.. the child table contains information of what equipment is being...

Yes, I get the specific record. I do this same thing to email the record to whoever I am invoicing.

Oh thats right...I made a special form that opens when you click that button. You just have to put this: "[InvoiceID]= forms!frmInvoicing![InvoiceID]" in the filter portion of the form properties.

I used this code behind a button DoCmd.OpenForm "frmrptCurrentRecordInvoice", acPreview, , "[InvoiceID]= forms!frmInvoicing![InvoiceID]" DoCmd.PrintOut DoCmd.Close

Hey All, I have some code that lets me know when I add parts to a reservation that is conflicting with an existing reservation. Its in the after update event of my subform and fires after I add an item to a reservation. The problem is I can't figure out how to get the warning message to only...

I did something similar except I locked all of the individual controls and put it in a function called LockAllControls: Forms![frmInvoicing]!cboInvoiceTo.Locked = True Forms![frmInvoicing]!cboInvoiceContact.Locked = True Forms![frmInvoicing]!InitiatedBy.Locked = True...

yes it can

See, I knew I did something stupid. Seems to be partially working. Thanks alot for your time!

Alright that worked, but now I have a new error. Run time 2342 - a RUNSQL action requires an argument consisting of an SQL statement. strSQL2 = " SELECT (([tblReservations_1].[DateOutReq]>[tblReservations].[DateInReq]) Or " & _ "...

Hi All, I have an SQL statement that keeps throwing a runtime 3075 error. I am sure I am missing something dumb, but if oyu wouldn't mind taking a look it would be much appreciated. "SELECT (([tblReservations_1].[DateOutReq]>[tblReservations].[DateInReq]) Or " & _...