Search results

Hi Just getting the feel of Access but definitely not highly proficient. I'm also starting to learn VBA. I have a form that I want to filter by different fields on different occasions. i.e., I might look at all records that have a review date of earlier than today on one occasion and I might...

Hi Just thought I would add that I created an -Open Form- Macro which caused the same problem. I'm not familiar with working on Macros so I converted my macros to VBA and sure enough it was the acNormal that was the problem

Thanks for the links. I'm on my way over now AJR

Hi Can't seem to find an explanation for why joins are denoted as left/right or Inner/Outer. If I know why it would probably help me remember which is which. Thanks AJR

Hi Thanks for taking the time to check out my question What I need to know is if I can somehow get a Totals Query to include a line when it returns a null value. A very simplified explanation of the situation: I have a database that generates a report showing different categories of Stock...

I'm using a very new (probably the latest) version of 2010.

Hi I am pretty new to Access but have been working on it quite intently for a couple of weeks. I have noticed that if you use the expression builder, in Report Design View, to insert a field from a query that is defined as the record source for the report (probably also from a table too but I...

Thanks for that. I'm on my way there right now. AJR

Hi Just wondering if anyone has a link to a site that explains, one by one, the purpose of each property on the property sheet? Thanks AJR

Duh. Seems obvious when spelled out for you. Thanks again. AJR

Galaxiom -Funny you should mention Continuous Form. I had a sort of feeling that might be where the solution lay. The cut and paste idea is brilliant. Probably why I didn't think of it. Thanks for the help

Isskint -Sorry to be so verbose. Seems to be a personality trait -you should see some of my complicated questions. In any case you have supplied a lot of great info. I just learned how to use After Update when creating Cascading Combo Boxes and After Change (Haven't caught the difference...

Hi Thanks for taking your time with my problem, even if you just read it and move on. I'm pretty new to Databases and Access and am just finishing off my first real Database. Sorry for using the S word. There are many reasons that this project should be done by a database, I'm finding one...

Sorry my reply is a little late--had some catching up to do after the holidays. Thanks for taking the time to respond. Turns out that my table structure was similar and the problem was at the query level. (As a Newb I didn't realize that one query could contain another. ) Viewing your table...

Hi Very new to access and just wondering why using lookup fields is so bad, errrr, evil? Should one use combo boxes in their place? Thanks

Hi I am a Newb who has almost completed my first Database. I have just one problem to solve that seems to be far more complicated (and taken far more time) than it should. As it is very complicated to explain the problem in the actual database (I tried and no one answered) and because I am...

Thanks Plog. Easy to accomplish and a good future reference. AJR

Hi Very new to Access and have just encountered this problem, which I cannot seem to resolve. I have a table [Cat1] which includes a field [Target%]. If I use this field alone in a query the % format will be maintained. However, if I use the field as part of this expression...

Hi I have worked with databases a long time ago (pre windows) and decided to see how much things have changed (lots). Currently working on my first Access DB and hope to eventually learn some SQL and VBA although that seems a long ways away at this (still confused) point.