Search results

Hi there, I have a form with two Subform controls on, one of them links to my orders form, the other to my products form(displayed as a datasheet), I apply the filter using VBA, if the form is set to continuous instead of datasheet, the filter works fine, otherwise it has no affect, here's my...

Hi there, probably sounds rude just dumping my database on everyone but I have searched and trialled and errored and gained no results, I know that I should have designed my database differently from the beggining but if I can save this one that would be alot easier, it won't need to be updated...

Hi there, I'm currently getting this error Run-time error '3464' Data type mismatch in criteria expression My Code causing this is Private Sub Label35_Click() Dim Weekno As String Dim repStr As String Weekno = InputBox("For Week Number...", "Enter Week Number") repStr =...

Hi there, on my form I'm using a drop down filter kind of thing, where you choose a field, then in the next combo box you choose a value, click filter and it then filters it all for you, the problem is, I have different data types, where as "Name = '" & combo21 & "'" 'Combo 21 will return a...

Hi there, I have this code in my form_dirty event, Price.Value = DSum("[Price Each] * [Quantity]", "[Products]", "[OrderID] = " & Form_Orders.OrderID.Value) Basically I want this to look in the table 'Products' for any value that has the same 'OrderID' as the current 'OrderID' on the form and...

Hi there, I quickly made a database, and for some reason, can't get past this 'cancelled' error, to get it to occur, open the Companies form, click orders and then it pops up. By deleting all of the data in my tables, I can get to a state where I can once again enter data, but after closing the...

Hi there, new to the forum but hopefully I'll become an active member quite soon :). Basically I have 2 comboboxes, Size and Part_No, I get the dreaded 2115 error while calling this event, the error claims that my beforeupdate property or validationrule property prohibit me from doing this, am...