Search results

This is kind of a long post, both questions are related to a similar topic of dealing with a large number of buttons. Question 1: I am attempting to make a macro to pull information based on a clicked button to provide information to another form. While my example below will be rudimentary, I...

I solved this, used a DCount instead for the If statement at ***1, and used simple intergers to solve problem ***2 by placing a variable set to 0 in the code and then changing it to 1 after a click, using an if variable <= 0 then...flash(see code above), else stop(see code above). Thanks for...

I was wondering if the line above marked ***1 could use a Dlookup like so; If DLookup("[Client]", "qryYearcheck").IsNull = True Then This would check the client value within a query that I use to check expiry dates, and would only cause a change if the values returned as not null (this is what I...

Thanks for the response, I'm not sure if my initial question explained my problem correctly so I am going to try to clarify. All I need is a way to show my users that IDs in the list have expired so that they can note them. I don't need an event on my query, i just need to figure out how to...

Something that I forgot to mention that could be of importance: I am currently working in Access 2003. Thanks in advance, ConfusedA

Happy Holidays everyone!! I had a question but I'm not sure if it's best suited for queries, coding or macros, it involves a query so i'm putting it here. However, I believe that code and/or a macro may be necessary to accomplish what I am looking for, so i'm going to break it into the three...

Ah, that makes sense. I'll agree with you about that name, I changed it and bracketed the term just to be safe. Thanks for the advice!

Hi everyone, So I've used this syntax before on many union queries and it has worked. Yet for some reason it now refuses to work on my new queries. I know that some of you will be annoying with my naming conventions for this (but unless that is where the problem actually lies, you don't need...

I have a select query, and if I accidentally alter information within it's results it automatically alters that record in my table. Is there a way to stop this? ConfusedA

Ok, so I have an idea for a solution, but I need to know if this is possible. If I have a value, is there a way to associate it with a set of values (sort of like a wildcard, but limited to a set of values given to it) I.E. for "Job" i would want it to be able to take up any possible used value...

Essentially what I need is an NZ() function that will work when a record doesn't exist from a query. Employee-cost, Truck-cost, and inventory-cost are all calculated in separate queries and sorted in to a job and 'month/year' basis. If there isn't a record for a cost associated with the...

I just mean like i have multiple tables of data; 3 main ones (one for employee work, one for when trucks are used and one for when inventory is used) they share 'job type' information as well as date information. Each is input in a different form, and not all jobs will include all three types...

I'm trying to decide if the easiest way to do this is just to place a null value for every possible option in to my tables and queries, but the problem is i will have to go through like 60 queries to ensure that it can recognize a null value when needed without wrecking any calculations.

Oh...and inventory, truck work and employee hours are all input seperately so they do not necessarily all appear for each job, because each has its own separate table that is used for calculating certain things.

Well it's too big to post and there are a lot of small connections that allow it to run, so it would be difficult to post just a piece of it. I can't manage to get my printscreen pictures up on here for some reason either, but I'll try to explain it from the overall picture to see if that can...

Thanks for the extremely quick response. I attempted that and I'm still not getting a value. I believe that the problem lies with the lack of records, NZ only works when there is an empty field doesn't it? I'm trying to account for situations in which the record doesn't exist at all. Thanks...

My problem: I have a set of reports that are created by a lot of queries. These reports collect together a bunch of information to create a totals section, my current problem is that there will not always be values for every field for each of the specific ways in which data needs to be...

Thanks for your thoughts Paul, I still haven't been able to figure out Dcount, but I created part of my solution, though it's still full of errors. The problem I'm having that I do not understand, is figuring out how to append if nothing exists. Like: say I have 3 values in a base table, and...

Using: Access 2k3 What I have is an input form for inserting inventory (type, amount, price, etc.) I use an append query to place each type in to another table. If the object is already in the table i'd like to be able to use an update query just to update the values. The query would be...

Here is what I have with my Gas/Diesel part of my inventory DB, the inventory used will always be entered on a week-month-year basis, for G/D it will be based off of Trucks and Jobs as well. I use a select query to make sure that the record being updated should be a single record. I do this by...