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

Thanks for the help guys, got it all working now, I'll have to design it better next time though :P.

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

Oh well, if you're still interested I'll get you the right code once I get home and can actually use access.

Try changing Private Sub Command9_Click() OpenAndNew End Sub to Private Sub Command9_Click() module1.OpenAndNew End Sub

If you click debug when the error arrives, which line of code is highlighted yellow?

Remove the On error resume next part from the module.

Did you cancel the wizard for the button? It should simply be a button assigned to do nothing.

Ok, from the main access window, go to the modules section, click on 'New'. After that you should be presented with a note pad look-a-like, enter this into it; Option Compare Database Public Sub OpenAndNew() Form_Day.Visible = True DoCmd.GoToRecord acDataForm, Form_Day.Name, acNewRec End Sub...

Ok, what is the name of the form that you wish the button to open?

Ok, an easy way to do this would be through VBA, have you got any experience in visual basic at all?

Got any code in your Mouse Move events for the header?

The teacher wouldn't ask of something if you weren't capable, I think you're just being pure lazy.

There is no maximum size for a file to be downloaded successfully, as long as they have space to hold it on their hard drive, it should be fine. Whilst working with .net you have to take into account that the end user must have the run time libraries for .net installed which are roughly 23mb if...

Nah, basically its just to check what week an orders due. Thanks for your help though :).

Yeah, no idea why I did that, I guess I'll leave it like that now. :o

Thanks :), turns out I needed the quotation mark on the last value :).

This gives me Syntax error in string in query expression '([Companies_CompanyID] = '1' and [Complete] = Yes and [WeekNumber] = '30)'. Edit: I shouldn't be so lazy and should've read through your code, now the error is Data type mismatch in criteria expression.

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

Use -1 as true/yes