Search results

Hi shutzy, Thank you for replying (and sorry for replying late). Yes, I have considered that as an option but if possible I would like to leave that as a last resort. There are a few other main-form-level buttons on my form which I feel should stay out of each individual control tab since they...

Hi all, I have a form with a tab control on it. The input for respective fields are placed inside the tab control, and I have the "Confirm" button placed outside, on the main form. Now I wanted to be able to navigate my focus from a control from inside to tab control, out to the Confirm button...

Ok, something strange just happened. I decided to use redo the form (using the form wizard again, as I did with my previous two forms) just to see where I could have went wrong, and this time, everything works. I can sort every single column now :confused: Most probably I did something wrong...

Do you mean the SQL code? Sorry if I misunderstood. ---------------------------------------------------------------------------------- SELECT [qry Sales Details].[Date Sold], [qry Sales Details].[Sale ID], [qry Sales Details].[Customer ID], [qry Sales Details].[First Name], [qry Sales...

Thank you for your reply pr2, Yes, I became aware of my naming problems later on in the project, but I do not think this is the problem. Like I mentioned the first query which I made several weeks prior works fine, and it uses the same name formats. Yes, in my codes the field names with spaces...

Hi all, I have created a form based on a query. The funny thing is when I tried to sort fields on the form, the following message box pops up: Syntax Error (Missing Operator) In (Field Name) I just did the exact same thing several weeks ago, and that first form could sort fields normally. The...

Hi EternalMyrtle! Thanks for your reply! I haven't tried it out yet, but this looks just the thing I might need. I'll try it when I have the chance this weekend. Cheers! :)

Hi all, I am trying to filter a subform on a tab control based on an input on a second form. Mainform: frm Index Page 2 Tab Control on Mainform: tabctrlMain Subform: Customer Details Tab Name: tabCustomerDetails The second form is basically a separate Search Form where users can look for a...

Hi! I have been looking all over the internet for this but haven't been able to find a solution. I have created a main form (frm Index Page) with a navigation control linking to every other forms embedded in it. For one of those forms, the CustomerDetails form, I have also created a form linked...

I'm no programmer, but I'm been trying to learn how to use microsoft access for the past year. Nice to become a member here :)