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

    if statement with "and" & "or"

    Does VBA allow the following... IF x or y and z then Dog = true end IF x or y , either one can be true, and z must be true... I can't find the syntax in HELP. This is used in Excel, but I can't use cell formulas for this task. Thanks Robert
  2. netscamp

    mysterious disappearing data on subform when tabbing out

    Now that you mention it, yes!. The data was transferred to the table. I'm wondering how I can stop that until a user has filled all subforms and sends all data to tables at once. Thanks for the repsonse, Robert
  3. netscamp

    mysterious disappearing data on subform when tabbing out

    I have a form with several subforms. To jump between subforms, I have an event triggered from the last text box of the subform telling it to set focus on the next subform. It works for tabbing around the form. The next step I took was to enter test dat in a subform, when I did so, then tabbed...
  4. netscamp

    bizarre conundrum - bookmark problem

    Call me Mr. Duh,..... Here's what is now working with no recordset involved at all... Dim currec As Long currec = Me.Form.CurrentRecord DoCmd.GoToRecord acDataForm, "trans_table", acGoTo, currec and it works on all 482 records. So, I guess I didn't need to do recordsets at all...
  5. netscamp

    bizarre conundrum - bookmark problem

    I have a subform and a main form. The sub is a datasheet view of the main. I have coded so that when I click the record selector(not the navigation button) in the subform, the main form sets itself to the same record number. There are 842 records. When I click the subform it works fine, until...
  6. netscamp

    addressing subform in VBA

    I have a main form - I want to put a button on the main to jump ahead 10 records in a subform which is in datasheet view, the main form is called "trans_table" the sub is "main3" I'm trying this code I got from the Access HELP files. DoCmd.GoToRecord acForm...
  7. netscamp

    VBA and reports

    I have a text box in a form, whose contents are calculated in a VBA module. The same form has a button to print a report. I want the button to fire some code that feeds a text box in the report with a value in a text box in the form. How to refer to the textboxes in the code ? Thanks a million!
  8. netscamp

    addressing a "cell" in a table, or, opposite of GetRows()?

    I changed my strategy a bit, and I'm not looping down through the rows, just finding the first blank that needs a calculation. That part is working, but the update, based on your previous suggestion is not showing up, no error, but not updating for some reason. With recset recset.MoveFirst...
  9. netscamp

    addressing a "cell" in a table, or, opposite of GetRows()?

    the math I'm doing - if the cell I'm in were called x,y - then the formula would be x,y = (x-4,y-1 + x-4,y) - x-3,y - x-2,y It's very spreadsheety. and I would want to go down a column filling in each cell with the values predicated on the prevous execution of the formula until I hit RowCount
  10. netscamp

    addressing a "cell" in a table, or, opposite of GetRows()?

    I used GetRows to fill an array with the contents of a table, now, using vba, I'm doing some math, and want to put the results into the last column of the table, I know how to do it in an array, or in Excel VBA, but how in an Access table? What is the name of the intersection of a row and a...
  11. netscamp

    forms/subforms/tables

    I have a form with 2 subforms. each subform has a table. In relationships, as far as I can tell, the relationships of the 2 "sub" tables to the main are the same. when I open the form, subform 1's behavior is: it shows the PO number which is shown on the main form, and if there are...
  12. netscamp

    clauses and punctuation

    Ok, first, I would like to say, I've just spent $90 on an Access VBA book, and an SQL book! and I've been poring over them, and referring to them like a demon with a fever..., but I can't get this right. It's working somewhat, but I know the query should return 5 items, but it is returning 25...
  13. netscamp

    clauses and punctuation

    I'm getting a missing operator error from ACCESS when I run this. It's in the select statement. Private Sub Command13_Click() Dim dbs As DAO.Database Dim qdf As DAO.Querydef Dim strSQL As String Dim lkval As String Dim jones As String Dim james As String james = Format(Now, "mdyyhss")...
  14. netscamp

    clauses and punctuation

    What if you want to pick specific fields from specific tables ? Ireally appreciate your time, and I'm going to contibute to the support of this service.... Thanks, RjW
  15. netscamp

    clauses and punctuation

    Ok, I've got the code below working, but I need to add some data from other tables. The select statement can have multiple from clauses? I can't find it in ACCESS help, and the book I ordered from Amazon is in the mail ! Private Sub Command13_Click() Dim dbs As DAO.Database Dim qdf As...
  16. netscamp

    why does it do that !?

    P.S. ! I got it! I used chr(34) in the string instead of typing in quotation marks. Thank you very much for your help. Robert Winters
  17. netscamp

    why does it do that !?

    thank you for the advice. I tried, as shown below... see line still, when I try to open the query, ACCESS asks me for a value with a dialog box. The variable "LKVAL" is being fed properly, as it shows up in the name of the query as expected. Private Sub Command13_Click() Dim dbs As...
  18. netscamp

    why does it do that !?

    the following code works, no errors, but the query it creates doesn't open, instead, when opened it puts up a dialog box asking for a value. I am trying to tell it, in line 8, that the criteria value is the contents of a text box in the subform which contains the button that fires the code. I...
  19. netscamp

    toggle subform visibility in access using VBA

    I would like to have a button toggle on/off the visibility of a subform in a form - in Access. in Excel VBA I would say "object.visible = true" , but that doesn't seem to work here.

Part and Inventory Search

Back
Top