Search results for query: *

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

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

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

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.

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?

I have a data entry form with a text box that holds the current date. The date is set by default(date() in the default property setting.) This process is transparent to the user. This method saves the date with the time. My user wants to sort on date. with the time included he only gets one...

I have a report on which I multiply the values in two text fields in a third field (text41) in an Access Report Text41's Control Source =[text212]*[Text30]. The value in text212 is $4,550. The value in Text30 is 55.921 My answer is $2,544.41. I need $2,544.40 How do I get rid of the extra...

I have a user who types records directly into a table. He asked, "Is here a way to insert a row where wanted". It appears Access goes to the bottom of the table for data entry when you choose 'add record' then sorts afterwords.

I have an on-click event that by necessity sets focus on a field to determine the value of the field. That's fine, but the user wants to return the focus to the first textbox on the form. Once focus is set on a control, is there a way to reset the focus to another control. It stops on the...

I have a query to run a report that selects dates more than 650 days old. The user wants only the most recent date of the dates more than 650 days old. How do I build this into the query design? Any help appreciated.

I have a data entry form with a field named [Statement]. The entry in this field is then inserted in a table via an sql insert statement. If the [statement] field contains an apostrophe it woun't insert. I know it has something to do with strQuote = Chr$(34) but I don't know exactly how to fix...

When I try to import a table from another database I'm getting the following message. "You tried to assign the null value to a variable that is not a variant data type." Does anyone know what is causing this and how I can get past it?