Recent content by BroncoMarc

The references on the computers that are giving the error are the same as mine: VB for applications MS Access 9.0 object library MS DAO 3.6 object library OLE Automation MS VB for applications extensibility 5.3 MS Calendar Control - Marc

I've got a database that many users here use that uses the Environ() command to identify the user. There are a few computers that come up with the error "Undefined Function 'Environ()' " when they load the database. What's confusing is that all the computers here are ghosted off the same...

Thanks!! I changed it to the following and it worked. txtProjNum = DMax("val(ProjNum)", "tablename") + 1 - Marc

I need to figure out how to automatically insert the next record number when someone hits New in a form to add a record. Easy enough.. Autonumber, right? Nope.. the field they're using in this database is setup as Text and there are a couple of records that have letters in the field. I don't...

Thanks.. that worked.. When I use a crosstab query in another query, will it update the columns if I try to change the design next month, or will I need to remove the table and re-add it?

I have an existing table that currently looks like this: Product Month Number Sales cogs 1 245 cogs 2 324 sprockets 2 352 sprockets 1 123 I want to use a make table query to convert the table to...

The MsgBox line gave me the same error. COMMENTS_TO_PRINT is a text box. I noticed after I typed Me. it popped up with a list of options. One of the choices was REQ__ so I tried that and it worked! This is what I ended up with: COMMENTS_TO_PRINT = "Credit Req " & REQ__ I thought I had...

I tried that already. It gives me "Microsoft Access can't find the field '|' referred to in your expression" Here is exactly what I'm trying: COMMENTS_TO_PRINT = "Credit Req " + [REQ_#].Text I wish the fields had normal names with no spaces.. This is what happens when the user makes their...

How do I reference a field that ends with a # symbol? For example My Field # I tried My_Field_#.Text but it didn't like that. I checked what Access called it if I tried to make that field an event. It made it My_Field___BeforeUpdate. I tried variations of that, but couldn't get it to...

I need my database to create a custom report number for sumbitting samples. The standard that they use is YY-MM-## where ## is a sequential number based on how many samples have been submitted that month. For example, The first sample submitted this month is 03-09-01, next is 03-09-02, and so...

Thanks!!! I've never heard of a Union Query and I don't know SQL, but I somehow managed to get it to work. :D You suggestion to create the right join and the left join, then combine them really helped too. - Marc

I've got 2 tables.. One with sales history and one with sales forecast. I'm trying to use a query to combine them. I've got joins set up with the common info (customer name, product) so it shows me history and forecast info at the same time in the result. My problem is that we have some...

I have a query that adds 12 months of forecast data, but some of the data contains nulls. The problem is that if any one of the 12 months contains a null it makes the result null. Is there an easy way to make it look at the nulls as zeros? The data is on a SQL server, so I have no control of...

I broke up my queries so there are seperate queries for the main form and all sub forms. I also linked all the subforms back to the main form. Now I'm back to the original problem. The data doesn't update when I change the combo boxes. Then I tried changing Me.Refresh to Me.Requery and it...

Wayne.. I'll have to load up some fictional data to post it here.. Right now it's using data from an SQL server and has about 2500 records. I was worried that it would be too large to post here (It was around 5 megs), but I copied the tables locally, then deleted 99% of the records and...