Search results

I have a report with a group header that distinguishes type1 from type2. I also have the heading for the columns in the group header. Depending on if it's type1 or type2 I would like one of the headings to change. Example: Type1 Name Address Phone Steve 12 Maple 911 Mark...

similar, but different question to my first one. I have a problem table, it has startdate and closed date. i would like to know how many problems were unsolved in given month. ergo the start date is less than or equal to some month, and the closed date is null or greater than that same month...

I'm trying to get data on the number of problems we have open on a given day/month whatever. but I"m completely stumped I know how to query the db if the problem happened during this month or last month, but what I really want is the total number of problems divided out by the months they...

How to I do a new line in a string. I'm trying to make an address line in a text box so it reads like this [fname] & space(1) & [lname] & "\n" & [address1] & "\n" & iif(isnull([address2]),[City]&", "& [State] & space(2) & [Zip],[address2]&"\n"&[City]&", "& [State] & space(2) & [Zip]) If i was...

OK I'm trying to run an update query. I have a table from which I wish to get a large amount of my data, it's a table that's sort of denormalized so we our users can run simple queries on it and get a variety of data. Here's what happens: When I use the denormalized table, call it foo, and...

Is there anyway to chain together my queries? eg, make table blah blah blah; update table blah blah blah; update table blah blah blah; update table blah blah blah; update table blah blah blah; alter table blah blah blah;

Any way I can add a column or drop a column in a query?

I'm using something to get the month from a birthdate, but I can't get a leading zero on the month. is there a function to do this, e.g. newfunction(month([birthdate])) tia, seth

I want to have a make table query that will create rows that are empty eg make table puts in IDnumber and has three blank columns 1) name 2) description 3) price for instance. I'll be creating a second query to update these columns, but I'll need empty columns. Thanks, Seth

Ok. I have a form that has a listbox with a number of items in it depending on the search criteria. I would like if a user double clicks the item in the list box for it to open another form that contains the data for that ticket eg. list box says ID Name Date Problem 2 Seth...

I have a list box that is propagated by a query that query has the criteria that the description field of the table should contain the value of the txtLookup field on the form. but if the description is "I like the car" I can only bring it up if I type verbatim "I like the car" I want it to...

When a user moves through the fields on my form when they reach the end where you submit the form if they press tab the form goes to a fresh form to enter more data. I do not want this if they press tab I want it to cycle back to the first box if at all possible how would I do this? Seth

I really want to have a text box to store my data, and the form I have looks up my data from a table. the table stores a Username. It's fine for me, but my coworkers would rather see a friendly name. I have an employee table to look it up in (e.g. arsmith => Amanda R. Smith) unfortunately, I...

I've a button that I'd like to make put the current date and time in a date/time field I have in my table. It is the table associated with the form. But I just don't know how to do this. Any ideas. I'm thinking I'll have to use the Now() function, but I don't know how to put it in the table...

I have a table that has a department name drop down box, once a user chooses the department the next field is item. I only want items in the previously chosen department to show up in the drop down box. I have a table that has all items, with a department name, and a table with department names...

I have an access 2000 database that I'd like to have people who use access 97 be able to use? how do I convert it most easily? TIA, Seth

I used the wizard to make a query for duplicates but there is quite a great deal of them, and I would like to delete all but one entry so that the following table: itema itemb itemc itemc itemd itemb iteme would be reduced to: itema itemb itemc itemd iteme Is there any way I can modify my...

An append query with criteria like this works: INSERT INTO tblA (item) SELECT tblb.* FROM tblb, tblc WHERE (((tblb.item)=[tblc]![item])); but when I make it a delete query it changes to : DELETE tblb.item FROM tblb, tblc WHERE (((tblb.item)=[tblc]![item])); it says "specify the table...

I've got a form with all kinds of data on it about a student, and I have a command button that opens another form that allows you to enter a memo about that student. I've bound the comment box to the memo field in the table, but I need to pass the ID of the student so that the comment can be...

I'm using code to disable a field when a checkbox is checked. Ex. If chkBox=-1 Then Item.Enabled=False Else Item.Enabled=True End If And I've had to put these in the OnCurrent Event of the form as well as the afterupdate on the checkbox. But. I'm using a tabular form, and it's disabling...