Search results

  1. F

    Viewing Non-Empty Tables

    Thank you worked perfectly. Makes my code look quite a bit nicer.
  2. F

    Viewing Non-Empty Tables

    Hello, I have a table called tbl2A. I want to open this table as long as there is some data in it. I have the code below that works very well. strSQL = "select * from tbl2A" Set rcd = CurrentDb.OpenRecordset(strSQL) rcd.MoveFirst If rcd.RecordCount > 0 Then...
  3. F

    Left Join Issue

    This is a very complicated query. I have two tables, tblFromBob and tblGenCol. tblFromBob has the below columns. Sim is the PK. sim cat_no tblGenCol has the below columns. Sim and Generic_col is the PK. sim generic_col Identifier now what I need is the sim, cat_no, identifier_1...
  4. F

    Paste appending from Excel file into Access table

    Hello, Have you tried something like this? DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "tblFromExcel", strPath acImport tells it to import acSpreadsheetTypeExcel9 tell it what format your excel file is in "tblFromExcel" is the name of the table you want to put it in strPath...
  5. F

    Not Updateable Query

    Ok I figured this out. BTW I am using Access 2010. When you go to the design view you have to open up the properties. Once there you will see amung other two options, Unique Values, and Unique Records. You must set the Unique Records to Yes. Onmce this was done, it worked. When I looked at...
  6. F

    Not Updateable Query

    Yes both tables are local and my primary keys are below. My primary keys in tbl2R is newCC, newMfr, newItem. My Primary Keys in tblInventoryItems is country_code, sim_mfr_no, sim_item_no.
  7. F

    Not Updateable Query

    I rebuilt the query in the query designer, and came up with the same problem. Can you think of anything else. Everywhere I looked says this thing should be updatable.
  8. F

    Not Updateable Query

    Hey all, I am using Access 2010. I have two tables, tblInventoryItems, and tbl2R. tblInventoryItems is just a list of items we have in out inventory. It has three fields, country_code(int), sim_mfr_no(text) and sim_item_no. The tbl2R is a table with a number of replacements. tbl2R has the...
  9. F

    vb.net and excel formatting.

    I have a question, and am not sure where to put it. I currently have an application that is currently an access app, but will need to be ported to vb.net. The problem I am having is that it creates an excel report. To format this report I simply created macro's in excel and pasted them into...
  10. F

    pass parameter query ?

    I believe you want to do something like the following. Set rs = CurrentDb.OpenRecordset("DivisionalLevelSpecific") Hope this helps
  11. F

    Selecting a Row in access

    hmmm maybe I can help. I know there is a function to do this, but as I always forget the unction name, and have had problems with it pulling the proper row anyway, I use my own code to do similar. let's say that intRndNum is your random number. You can use code like the following to get the...
  12. F

    Loop Syntax

    it looks like the line with the next statment is wrong. It should be as follows. next intCounter
  13. F

    Changing public variable via form

    text boxes don't use the .value, they use .text. If you want to set your variable to the text in a text box you will want to use. pass1=text21.text if you use this you will need to give text21 the focus, you can also use the following to get around that. pass1=text21 either should work.
  14. F

    setfocus problem

    awesome that worked. Thank you very much
  15. F

    setfocus problem

    I have a form that has a group of text boxes. The top one is a customer box and the rest is unimportant. What I need to do is to fill in the unimportant tesxt boxes on the change event of the customer box. To do this, I have to setfocus to each box individually update their information, and...
  16. F

    Appending Data from SQL Server into Access

    I have run into a similar problem. Depending on what you want to do you can try to simply import the sql tables to access tables. Although if you need to work with live current data, this would not be an option. There are two ways I found to speed things up a bit. The first is to use a...
  17. F

    If Statement Against a Check Box

    try just using If Me.ChkPerm Then Me.txtBOX.BorderColor = 16711680 Else Me.txtBOX.BorderColor = 10711680 End If
  18. F

    Exporting to Wordpad/Notepad/Word etc

    I don't know if this is what you want or not, but you can use something like strFileName="filename.txt" Open strFileName For Output As #1 Write #1, field1, field2, field3 Close #1 This will create a comma delimited txt file. you can then open it with whatever txt editor you like. I hope this...
  19. F

    error with the Eval() function

    I have a string that has only a function name in it. I want to call the function name that is in the string. my function is called goodtime. I have the following code. Public Function goodtime() As String DoEvents goodtime = "testing" End Function strTemp = strAnswer & "()"...
  20. F

    Need VBA Code help

    try something like this. dim strTemp as string strTemp=combo7.value While InStrRev(strTemp, Chr(44)) strTemp = Mid(strTemp, 1, (InStrRev(strTemp, Chr(44)) - 1)) & Mid(strTemp, (InStrRev(strTemp, Chr(44)) + 1)) Wend Set rst2 = CurrentDb.OpenRecordset("Select * From Product_Master " & _ "where...
Top Bottom