Search results

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...

Brian, I created the new calendar table and now the query executes in about 5 secs. :) Thanks for the tip. Z

Hi Brain, I understand what you are trying to say. I'll give it a shot and is if it imporves the performance. The reason why I chose to use start and end dates is simply because its easier to update as well as enter 12 records rather than 366 records, but if that improves performance...

Hi Guys, I have a query that runs fine but takes a while to run. As a consequence all queries and reports built on this query slow down resulting in poor peformance. Let me first off try to explain what I'm trying to do and point out what is slowing down the query. I have a table with about...

Pat, I exported the table into excel and ran some code to group the data the way I needed it. It all worked out. Thanks for the help though. ZDog

Hi Guys, I agree and understand your question, a field can only contain one single data type. In the case of the table that I'm dealing with the fields actually are text fields although most of the data consists of numbers. I'm pretty sure the data wasn't meant to be used in a db table however...