Search results

Copying the master navigation form didn't fix it. I found a workaround though. Luckily I keep backups every once in a while. I found one of my backups, deleted the master navigation form from the database, then imported the form from the working database back in.. Works now. Thanks for all...

That's not a bad idea JHB, I'll give that a go.. Thanks man

pr2-eugin Went to the link and tried the decompile. Made no difference unfortunately. But thanks for the info. MSAccessRookie I have done some whiteboxing on it and the only form which I cant access using the [Forms]! query criteria reference is the main/master form. The problem occurs...

Tried and it made no difference

Hi, I am having an issue with a database application I created. I needed to add another query that could be controlled from combo box on a nested form. The combo box is for dates for entries in a table. Which then filters the query based on the combo box selection. Easy enough stuff. The...

Genius mate! Thanks a lot..

I have a table of trainees. One of the fields of that table is 'authorized trainer' (YES/NO) tick box. What this allows me to do is query the trainees table based on who is an authorized trainer, and who is not. I have a table of called training, that records information about training a...

I have searched the forum for threads on icons and haven't found one that relates to what I'm about to ask. I have an access icon (*.ico) file associated with my DB. But when I try to access the database from a place other than my desktop where the icon is located the icon doesn't show up. Is...

Sorted http://office.microsoft.com/en-au/access-help/compare-two-tables-and-find-only-matching-data-HA010205130.aspx

So, I couldnt get either of those suggestions to work properly for me, no doubt they were both excellent suggestions, so thank you very much for that.. Heres where I am going. I have created two queries, one that shows me customers who have purchased product 1, and one that shows me those who...

So in this code you have essentially create a new table that duplicates the info of tblOrder and tblOrder_1?

I'll give those things a try now lads, thanks for that!

I have a table of customers, and a table of products. I also have a table of orders. Each time a customer orders a product the details of the customer and the order are added to the orders table. Pretty standard. I have a query that shows customers who bought product 1 and 2, but none of the...

I got it to work!! Whohoo.. lol Your information on how to print the report from the form was excellent, thanks a lot! You have saved me a lot of hassle, still think I'll learn VB though.. I'll write up a complete post on exactly how I got it to work in case its of any use to any other members..

Ok, thanks.. Everything you have shown me so far is 100%.. I have figured out what is going wrong for me.. I am using forms that are embedded in navigation forms. When I try to use the functionality from a form outside of the navigation form everything works perfectly. When I use that same...

Ok, that works perfectly, it prints the report from the form using a button.. But.. Thats actually not the question I asked, even though its very useful, so thanks.. What I wanted to do was this.. I have a form for inputting a customers details, including a subform for a customers purchases...

No I substitute LinkField= to CustomerID=... Is that right?

Cool beans man.. Your teaching me a lot here, thanks.. Just one question about the "LinkField=" & Me!LinkField Should I put "LinkField=CustomerID" & Me!LinkField Or, do I need to add/change the Me!LinkField part? Or is that a generic keyword that basically links the preceeding code to this...

No, I just put in the code that you gave me a couple of posts up.. I can see now when I check in the VB editing window that there are other criteria that I need to enter like the WHERE keyword etc. As I said, I don't know VB, if this were JAVA or SQL this would not be a problem, but I have been...

Yea, so that works perfectly, thanks. But, do again, when I make the reports that way, the subreport displays the customers purchases, and the main report displays their details. But because I've based the reports on the entire table I can't limit the results of the report to a single...