Search results for query: *

Thanks for all the quick responses...I've been in meetings all day so I didn't check my mail until this evening. To answer Ethorn10 question, yes the tables is laid out as he displayed with fields of q1, q2 q3 etc. I will try your suggestions tomorrwo morning and let you know how it works out...

Before I start I should mention that I am only new to ASP scripts so I appologize if this seems like a simple question. The site I am working with is a survey page where users can answer 1-5 for any of the 34 questions. The answers are then written back to an Access databse. This part works...

Thanks for the info... I was able to eliminate this error by removing the check mark next to shappmgr 1.0 Type Library. I'm not sure what this library does, but the issue appears to be resolved.

Thanks, I removed the check from Shappmgr 1.0 Type Library and now the error has gone away. In fact it also corrected an issue i had opening a form as well. Do you know what this Library is and is it something I should worry about not having/using? Once again, thanks for the info.

Here is my situation.... Our IT department upgraded us to Windows XP and Access 2000 (9.0.3821 SR-1) and this has caused problems opening a filtered form. The error I'm getting is "This is an invalid use of the . (dot) or ! operator or invalid parentheses". Here is the code the...

Here is my dilema..... Out wonderful IT department decided to upgrade our PC to Windows XP and Access 2000 (9.0.3821 SR-1). This has caused several issues with some previously working code. When the following code is run it stops on the first line and hilights the word left and gives the...

He Guys, I need some direction with an issue that has been ongoing for sometime. As you know Access likes to create a lock file (.ldb) each time a database is opened and removes it when you close it. The way my database is currently setup users log in using the accounts created under a...

Thanks, That worked fine and now I have a better understanding of this line. Now, I do have one last request which I feel guilty asking since you've been such a great help so far. anyway, my supervisor wants to ensure the code isn't easily duplicated. She was thinking about having the 2...

mstrmage1768 (Programmer Thanks, it worked. It was just the typo, I feel stupid that I missed something simple like that. Now, if I later decide to cut out the year and have 4 random number. I assume I would first of all rem the lines dealing with the date but I don't fully understand the...

First of all, I want ot say thanks, for your time and patience with this. Now there is a slight problem I'm having.... The number being generated is just something like 0365. The first 2 are the the year and the last 2 are randomly generated. It is missing the initials and case number. Here...

He Guys, I first want to start out by apologizing for my late response, I was called away to meetings fo rthe past few weeks. Anyway, I've given some thought as to how I like the code to look. I want to use the first and last initial of the current user + the last 4 digits of the case# + the...

Thanks, I'll give that a shot. I'll try and clarify what I want to do...... I have a form that records information pertaining to incoming calls, some of that information will be a case#. Basically, it's a tier1 agent calling tier2 agent for advice on a case. The tier1 agent calling in will...

Here's my dilemma.... I'm looking for a way to build in a random code generator that I can embed into a form and have the result stored in the table the form is based on. If the code could use part of the date and/or username in the generated code that would be even better. I'm not a...

Thanks, I'll give this a shot tomorrow when I get to work. However, there is one question I have. If the form is unbound won't the fields on the form display as #name# now since it doesn't now where to store the data? Three of the fields are drop down boxes where I specify the control source...

This may be a simple question but it would really help speed things up with my database. The form I have now uses a table as it control source. Several users are entering information into this form at the same time and thus this table grows very rapidly. As the table grows the amount of time...

Hey, I've been working a database that essentially schedules calls. As a result we will inevitably have to reschedule calls for certain customers. Rather than modify the existing schedule record I want to record this as 2 separate records but have most of the information from the first...

Thanks, This is excatly what I did and was able to creat the file. I initially thought the compile was done during the creation so I overlooked that.

This is the first time I've run into this error and was hopeing someone can give me a hand. The database is setup so that the data tables are stored in one database and the linked tables, forms, queries, etc. are kept in what I've called the build version of the database. I also created a...

BakerUSMC, If I undertand correctly you have a form where the criteria is being entered and a button the will run preview the report based on the data entered. I have a similar setup with my own database and the way I did it was through using ME statement in the criteria fields on the query...

Sorry, about the delay in replying to this but I did manage to figure this out. There was a typo on my part. Thanks for the help