Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. VhbuiA

    Set combo value if check box is not checked...

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

    Set combo value if check box is not checked...

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

    2003 Developed Report Hangs When Opening in 2000

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

    Can I just copy a report instead of whole MDB file

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

    Access says a table is open so I can't change any data!

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

    DLookUp Help - Error 3464 Data Type Mismatch

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

    Tricks to formatting a report?

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

    how to get query ot show data

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

    criteria used in query

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

    how to get query ot show data

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

    Forms samples

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

    DoCmd ?

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

    Update Table with FK

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

    Update Table with FK

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

    How to add data into a field based of the value of another

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

    How to add data into a field based of the value of another

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

    DoCmd.TransferSpreadsheet

    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!
  18. VhbuiA

    DoCmd.TransferSpreadsheet

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

    Modify VBA Code in a .DOT file

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

    Modifying AutoCorrect Commands in WORD

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

Part and Inventory Search

Back
Top