Search results for query: *

PHV that worked just right, Thanks

I have the following code that increments to the next number each time a form is opened: X = DMax("[REF#]", "OrderTBL") X = X + 1 Me.[Ref#] = X Is there any way to add the prefix "E" to the number so it come out like E1,E2 etc.. I concatenated it but that only worked once, then the next...

I have an existing Access Database with one remote user. That user complains that his connection is too slow. I'm looking into the possibility solving this problem by putting the Application on the Web. I have no experience at this. Can someone give me an idea of what is involved? Thanks

I have a table of 150 names. I want to run a report based on a query that picks the next ten names on the list each time the query is run. Once I acheive this I want to choose the actual number of names. (it won't always be ten but must always be the next in line) I need ideas on how to do...

Thanks, I'll give this a try.

I have an application in which the user needs to foward a record that includes attachments. This is new to me. How is this done? I was able to create a form and insert a word document but I don't think this is good enough because it won't hold much information. Any ideas on other ways to do...

To hkaing79, I think that will work fine for the enter key. I was not aware of this property setting. As for the tab key, I'll just disable it. Thanks Again, this should solve the problem

I have an inquiry screen where I want the user to have the capacity to input extensive details about a record. I tried putting a button on the screen which when clicked opens another form. On that form I put a memo text field and expanded it to the length of the screen. The problem with this...

Thanks for the tips. I tried each one and it made no difference. All things seem to be equal but the fields display differently.

I run a report with weekly and yearly currency amounts. Two fields with identical property settings pull the same data from different time periods. At present no data exits. When I run the report ,one field comes up with $0.00. The other comes up blank. What determines this? I want both...

I'm developing a "Master Query" to run a summary report. It requires 33 sub queries. After adding 30 sub-queries to the "Master Query" I get a message that says "query is too complex" and it won't run. Does Access have a limit of 30 and if so how to get around this. Any help greatly appreciated.

The problem with that is the user does not want it to be a text field. They don't want entry people to have the option of entering alpha. In addition, they have the same situation in another database and the zeros hold. There must be a way.

Molby, Thanks for the response. It seemed to work at first but when the user went to query the record, the zero was gone again. Any ideas on how to make it stay?

I have a numeric field that will only take 9 digits. I changed it to "Double" but i'm not sure what that means. Is this the correct way to expand the field size? Any Help Appreciated.

I have a numeric field for SSN with no dashes. When the user enters an SSN beginning with Zero it automatically deletes the zero. How do i get it to stay? Please Help!

I have an assignment table in which I need to assign employees to projects based on a percentage of thier time using a certain skill. Each employee has a limit of time for each skill. This limit is set in an employee table. For instance I'm assigned 50% of my time to Access programming...

I have a table called AssignmentTbl that has three fields : Skill,EmpFname,EmpLname. I need to populate all three fields at once from another table (employeeTbl)which has the indentical fields. I tried making the Skill field a ComboBox but that only worked for that field. Is there any way to...

I have a table with a numeric field. The value entered into that field must not be higher than a related field. How do I put a restriction on the table to prevent entering a value higher than the related field.

I have a report that has dollar amounts in 2 text boxes. I'm trying to add the two in a third box. Control Source =[Text1]+[Text2]. Instead of adding them together it's putting them side by side. Anyone know why?

Thanks, that's what I needed to know.