Search results

I have 2 tables. The first is setup like this: ID, NUM, VALUE 1 5 Dan 1 11 11/01/1985 1 65 Length 1 32 86 2 5 Dave 2 11 6/15/1972 2 65 Length 2 33 44 3 5 Greg 3 11 9/041961 3 15 53 3 8 M...

First off - I must have not been very clear in my first post. Both answers are telling me how to find or select sales that are zero. That is the opposite of what I want. I want to to find the first month of sales that are *not* zero. So if sales$1, sales$2, and sales$3 have zero in them but...

I am not so great at writing functions from scratch, rather I generally have to find something that sort of accomplishes a similar task and then modify it to fit my needs. Unfortunately I haven't been able to find anything this specific yet. The idea is that I have a table with products. It...

My memory is not what it used to be... what a horrible feeling that is! I have a table that track monthly data for several thousand products. The idea is to grab the first month and the first three months of sales for each product. So I simply need to have a statement that scans through a...

it is telling me it can't find the input table. and the debug takes me to this line: Set rst = db.OpenRecordset(Food) If food is the name of my table, this should work, right? edit1; i changed it to: Set rst = db.OpenRecordset("SELECT * FROM Food") and that worked great for me.

I know how to make a query using SQL or through the design wizard... how do i make a query using VBA? I have only used VBA in the module :/ edit: ah wait, i read it wrong. This is a function that calls a query.... I get that now. But I'm not sure how to modify this to work for me.... have to...

I have a simple function that expects a string variable to be passed along to it. My intent is to send the contents of a column from a table as this string, so basically for every row in my table I want to pass the contents over to my code and have it run. So lets say I only had 3 rows in a...

figured out the setfocus issue.... now it is just a matter of setting it to something unobtrusive thanks for the help getting here.

I also worry that then I have to have a random text box that has nothing to do with the form itself..... as the object with setfocus defined can't be hidden..... Maybe I can set it outside of the window...? But then the setfocus would shift to it I believe.

Arg, I hate forms. So I go look up "setfocus" and it just tells me to type: Forms!Employees!EmployeeID.SetFocus Where does one type this? The buttons properties does not have a setfocus section.... As I said before, i really don't know forms very well. I make buttons that run processes, and...

Is there a way to make it auto focus on the text box? Otherwise it will just error out when the form opens?

Thank you for the suggestion, I'll look into this

I was not so much expecting to use javascript as finding another way to accomplish this. I spend most of my time working with the queries and such... not nearly as familiar with forms.

A break from the more serious threads. Using jscript on a website it is possible to make a user button "runaway" from the mouse cursor. Got a new guy coming in to learn one of the databases I've created and I'd like to have a little fun, so I was thinking about doing something similar with the...

Thanks for the input. Using either single or double modifies my original numbers by adding decimal places. using integer right aligns it within the database, but it is still left aligned on export. It seems that the problem is not how access stores the data within the table, but that access...

I have been searching for solutions to this problem, yet all I have found are little work arounds - nothing that directly addresses the issue. I have a file that we import using another program. I have written an import spec to bring it into access where I will prune out some entries. At this...

That was it. Not sure why I took that last part of the command for granted and never looked into what exactly was "true". thank you very much.

It looks like you were on to something. There are duplicates that should not be there, and the update process has only been updating the first instance. This means that it sees itself twice in the original table, and of course it is different than one of the instances. The primary issue here...

Because I am not aware of another way to make a difference table. It is very important for this process that I know exactly which records have changed or been added. The way I came up with doing this is comparing the updated table to the original table, using the method described above. If...

I have a query I use across 20 tables to check for differences for them. Before my updating process begins my original table is copied to a backup table. In this case the original table is named "vermillion" and it is copied to "vermillion_b4" as a backup. Generally I then run updates on the...