Search results for query: *

Thanks for responding! Sorry for the confusion...I do have more controls on the form itself but only the three mentioned is related to what I'm trying to accomplish. The fourth control was just additional information regarding the text box. I'll give mhartman1's suggestion a try and see what...

Hi, hopefully this is the right forum to post to. Here's the background: I have three controls on an unbound form: 1. Text box that gets its value from a combo box whose row source is a query 2. I have another combo box whose row source is a table 3. I have a check box What I want is to have...

Hi, I have a report that was developed in A2003 which I had to migrate to A2K. When the report was in A2003, it took less than a minute to load but when I try to open it in A2K, it hangs up the system and eventually freezes. The underlying query is complicated but doesn't contain that many...

Hi Cheguvera Assuming that you didn't change any of the table names, field names etc...you can open up the new database and do a FILE>>>GET EXTERNAL DATA>>>IMPORT>>>select the old database file which contains your report and then when the dialog box pops up, just choose (or select) the report...

Hi andegre... If this is not a multi-user database, I would suggest, depending on which version of Access you have, and looking up the Advance Tab under Tools>>>Options to see if you have the database set to Open Exclusively. Hope this helps...

Hi, I've searched the site but nothing I seem to change works for what I need accomplished. I have a form that basically after a user types in the SSN in the txtAS2 field, the code would then look up the values associated with that SSN in the employee table. Here's what I have so far...any...

Hi, I have a main report which contains 2 subreports. I'd like to lay both subreports next to eachother so that it appears as though it's on one line. Ex: sub1 sub2 Awards Given Awards Allowed Q1 Q2 Q3 Q4 Award1 100...

Sorry for not explaining better, I think that I need to use the Nz() function (but I'm not very familiar with it) but maybe if I explain to you the table structure you can point me in the right direction? Table X EmpID OrgID AwardID QtrID AwardAmt I basically need to create a query that looks...

Let's see your SQL statement...I tested it on my end and it shouldn't be a problem. Could be a typo.

I have a related question, I think...how do you get a query to show a value of 0 especially if that value doesn't exist yet in the table? I have a table used to document awards given but I want the query results to show all the award types in all quarters even if there are no awards given...

Hi, check this out: http://office.microsoft.com/en-us/assistance/HA012341591033.aspx

Hi Kermit! I'm fairly new to VBA and the programmatic side of Access however I found this site to be very useful in helping me understand the basics (i.e. "SYNTAX"): http://www.functionaccess.com/vbaccess/ Also, this book: Microsoft Access VBA Programming for the Absolute Beginner, Second...

Thanks lupins for your response. I think I did not do a good job explaining. The problem is I get data from another source that gives me a ID code for an employee (X) and then an associated organization that the employee belongs to (Z). In order to normalize it, I had to create a reference...

Hi, I am fairly new at VBA so please be nice =) I am having problems updating a table with a foreign key if I already have a field that matches in the other table. Please let me explain: tblA X (PK) Y (FK) Z (FK) tblB Y (PK) Z (PK) In table A, I already have data populated in Field Z. This...

Thanks! It worked like a charm...=)

Hi, I have done a lot of research and have not quite found the solution to a problem I am having...hope someone can point me into the right direction. I created a table using VBA to pull data from an Excel spreadsheet into my db. However, I only require select fields for the purpose of the db...

Change it to "Sheet2!A1:G200"...the brackets around the sheet name doesn't work for me. Also, just a suggestion to shorten your code a bit, you can replace acSpreadsheetTypeExcel9 to 8 (means the same). Hope that helps!

MrsMope, I tried both suggestions and lupins46's suggestion worked. Could we see your variable definitions? Also, what version of Access are you using, I saw in Help (see below) that the range syntax may not work with 97 or 2000... "Range: The range of cells to import or link. Leave this...

Gerry -- thanks! It is an autocorrect issue and this is definitely the piece of information I was looking for! I will it a try!

Hpwdy! How do you modify an AutoCorrect command? Basically the previous developer created AutoCorrect commands so that once a series of initals (say abc) were entered into the word document, the electronic signature would appear in the document. The commands are stored in a .acl file but I have...