Search results

Hi There, Any ideas on how i would filter a form using an option button. E.g i want to be able to click an option button that is called Filter user and it will filter the query based on who is logged in? and a Filter all option that will clear the filter and show all records? thanks

Hi there, im trying to autosize list box columns depending on the size of the largest field in the column? Is there a way of doing this? thanks

Thanks that sounds like what i need, what kind of code do i need to do this??

I moved the ' further along and it is now working =DLookUp("[EmailAddress]","[qrySupplierEmail]","'[SupplierPK]=" & [Forms]![frmPurchaseEntry]![SupplierFK] & "'") thanks for pointing me in the right direction!

thank you for the reply, I have tried the following =DLookUp("[EmailAddress]","[qrySupplierEmail]","[SupplierPK]='" & [Forms]![frmPurchaseEntry]![SupplierFK] & "'") with the same result? The error# flashes in the textbox?

Hi there i am trying to do a Dlookup in an textbox which is looking at a query that isnt a bound source of the form. my code is =DLookUp("[EmailAddress]","[qrySupplierEmail]","[SupplierPK]=" & [Forms]![frmPurchaseEntry]![SupplierFK]) Im looking for the field Emailaddress in the query...

any more thoughts?? thanks Aron

Just wondering if anybody has had any luck linking to an active directory. I want to link into the active directory to get a list of staff usernames, so it will update the user table as new members of staff are created etc. We currently have around 130 staff, so rather than manually updating...

I understand it sounds strange, But when the form is opened all of the Order PK, FK are automatically populated from the previous form. So the order table has all of its relevant information. The subform that controls the orderDetails is blank when the master form opens, as soon as you type in...

I have a form that opens up and fills in all of the Orders Table when it opens. I then have a subform that is used to fill in the order details. Currently if they open the form and then close it, it creates a record in the order table. I want to be able to delete this record if no information...

Of course! thank you!

Hi Paul, How would i get my query to display a 1 if the count = 0? at the minute it needs 1 order being placed before it shows a record. I want it to show all the staff in the query and if they havnt placed an order i want it to show 1? hope this makes some sense?

Worked a treat thank you!

I am after some advice, i want to track how many orders a user makes. So every time they place an order it increments 1 after each order. I currently have the following tables, Order OrderDetail User Should i create an UserOrderHistory table? Eventually i want this information to form part of...

Ah just had a bingo moment, i have changed it to the query that the subfrom is based on. Found the error of my ways! thanks

sfrmPurchaseOrder is the name of my subform, isnt the subform control the textbox which we call SFTotal?

Yep just doubled checked and the text box on the subform is SFTotal??

Oh i see, i have tried the following Textbox In my subform footer =Sum([Line Value]) Textbox in my main form =[sfrmPurchaseOrder].[Form].[SFTotal] Im getting #Name? in the textbox on the main form?

Thank you for the reply, but will this work as my subform is a datasheet, which dose not allow form footers? thanks

After having no luck with the standard datasheet E-Totals, i'm now trying to have a textbox on the main form that totals a subforms column called lineTotal. Line Total is a calculated query field that works out the Qty*cost. So say if they put in 5 lines on the subform, the textbox field will...