Search results

I have just noticed something which makes things a little complicated... the button doesnt seem to work with a 1 to many relationship... for example, an Order holds an OrderDetails (one to many, one order can have many order details), however wehn i click the button in the order form to open...

Th button wizard isn't creating buttons properly!? I need it to create a button that opens a form relative to the customerID already in use... but it doesn't seem to work and it just brings up the first record and says it's been filtered, when clearly is hasnt. Option Compare Database...

help anyone??:(

somehow the file didnt upload... oh well here is a zipped version

I created a wizard type form system, but it doesnt seem to want to work if theres nothing in the next form. For instance I have a customer form with a Customer ID (tblCust), a button on this form opens an order form (tblOrder), which has a customer ID and an order ID. I used the button wizard...

Good point Rabbie, Through all this random testing with Dummie entries, Im already upto OrderID5... even when I delete previous entries. I shall try that out ASAP!

Invoice table with Autonumber... interesting.... How would I import the data from other sources?

DCrake, that sounds quite complex yet simple? The OrderID, is connected to Orderdetails ID, finishing ID and Depatment ID... I would therefore have to create it for invoice and one for quote... Plus I wasn't aware of how to append tables to another table? but your way of doing this does make...

I just stubmbled across a problem I have, which I'm sure has a simple solution, but I cant think of anyway to do it? (DMAX+1 comes to mind perhaps?:confused:) I have an orders table, and you select an order type: either Invoice or Quotes (Where ordertype=1 for invoice and 2 for quote) At some...

Yup. I am summing up many things in the same query though, Sum([Price]), Sum([Discount]), Sum([VAT]) etc... I just figured that if I make each one it's own query, then use a query to string them all together into one big query. Very messy but it works. I still dont understand why it would do...

yup, same computer and everything. My real database is getting quite messy so I started testing things in new .db files.

I have a column (Price) with £10,£20,£30 in 3 seperate records. I use Sum([Price]) which should return £60 but I get £180... which I realised for some reason the total is multiplied by the number of records. For instance £20,£30 should give £50... but it doubles it to £100 Why is this happening?

ACH - why is it one day something works, then the next it doesn't?. I tested it on a tester database and it worked, I ticked a box and the date appeared as today. I could use Date() or Now(), I think for this case Ill need Date() because a query will be run for those which are unpaid for 30days...

Cheers! Worked a treat! :)

Im not familiar with the on click methods?

Im creating a query, where a check box (paid) enters "Now()" into a date field, labeled "Pad Date:" I thought a simple query in the citeria of the "Paid Date" box Switch([Paid]=Yes,"=Now()") would solve this porblem. I was just thinking, perhaps a blonde moment... will this enter the date...

The code below is for a search tool, but it returns an error if there isn't any data in the CompanyName field. To get around this I want to divert it to the LastName if there isnt anything in CompanyName. I thought I could create a variable (CompLast) to use instead of using either...

Private Sub QuickSearch_AfterUpdate() DoCmd.Requery Me.RecordsetClone.FindFirst "[CompanyName] = '" & Me![QuickSearch] & "'" If Not Me.RecordsetClone.NoMatch Then Me.Bookmark = Me.RecordsetClone.Bookmark Else MsgBox "Could not locate [" & Me![QuickSearch] & "]" End If End Sub I kept...

oh thats good then - what does Dmax do? Ive been told about it before and looked into it but DMAX didn't look relevent?

How does the index count up - it uses autonumber right? How can I use autonumber on a query to count up, but not like 1,2,3,4,5... but it counts similar data, like A 1,2,3,4,5... B 1,2,3,4... etc... does this make sense? (see image for example)