Recent content by zdog

Rak , appreciate the response. In fact when I created the db, I actually set up a seperate table which has the request number and a yes/no authorization field. However the managers don't want to use access for the authrozation part. It makes a lot more sense to me as a developer to have it done...

I've got an interesting problem. I've developed an access database to log all sales requests. Each request has to be authorized by the site manager. I have the entry form in access setup so that when a new entry is made an email is sent to the manager with an attachement (access report)...

Thanks for the response Roy. I did end up using a query, worked perfectly. Just out of curiosity, what is the movefirst/last command supposed to do???

Hi Guys, This things been driving me nuts. What i'm trying to do is copy certain fields from one table into another. Heres part of the code I'm using... Dim rst as dao.recordset Dim rst1 as dao.recordset Set rst = CurrentDb.OpenRecordset("Entry_Log") Set rst1 =...

You could add a new column in both the excel worksheets called concatenatedname, first name&last name. You can then do a vlookup on that column in excel itself to check if the full name exists in both files.

A select query should do the trick select the date in, date resolved, and any other fields that you wish to be display. No set the criteria for the date resolved to Is null, this will address the first issue of selecting only open cases. Now create a new field in the query, let says week_num...

Canary, In the sample db I am using only 1 form and not 2 like I suggested earlier, I realized that one form was sufficient. I've converted the db to 97 hope it works.

Heres a sample db for you

Hi Canary, I would use a form and a subform. The form would have a combobox, the source for which would be the ID field from the table. The subform would have a textbox that will be updated based on the selection in the combobox on the main form. If you need further help with setting this up let...

Hi RMiller, I can't think of a way to acheive the desired output using a single query, but you could use two queries. The first query would select the max value from the demand field and is grouped by the week field. You then use this query to reference the table to determine the date when...

Glad I could help out Rob. As for you question regarding the form, my guess would be that it should work. I'm assuming that you would like to specify the table and field name based on textboxes on a form. Only change that you need to make is that you don't need the double quotes around...

Hi Rob, I think the best way to address this problem is using vba code. The general idea is to navigate the recordset, and assign the value in the field to a variable if it isn't null, if it is null then use the variable as the value of the field. I've marked a couple of things that you will...

Problem solved. :) Thanks Chris, using "resume" instead of "goto" solved the problem. meboz you might want to try it out as well if your error handler is structured similar to mine, worked for me hopefully it will work for you too. Thanks again guys, ZDog

Hi Hudson I changed to code to the cleaner version that you suggested however I still run into the same problem. For some reason access doesn't seem to recognize the line On error goto Error_handler on the second attempt. Like I mentioned earlier, works just fine the first time I cancel the...

Hi All, My question is with regards to the error handler that I have. The code below is only a partial extract from the code on the form. Essential the code attaches a report to an outlook message. If the user doesn't send the email, it runs through the error handler and asks the user to...