Search results

  1. A

    Beginnner needs help!

    Start with the database that has the forms in it. Go to the File menu and select Get External Data...Import... Find your database with the full tables and double click on it. Select all of the tables you want to bring over and click OK. They will be brought over to your forms database. If the...
  2. A

    Shared Data Entry - Sorting ?

    Set the Order By property of the subform to [YourSubFormsTable].[YourDateField] That'll do it.
  3. A

    Conditionally change text color

    I know how to change the color of currency based on Positive,Negative,Zero, and Null but how do you change the color of text based on some other criteria. Changing the .ForeColor parameter changes all of the records in the field for that control and that is not what I want. For example, I want...
  4. A

    Create Select List Based on Results from Previous Field

    Which parameter does it ask for? In the Criteria line are you using the name of the combo box in: Like Forms!yourmainform.CostTypeComboBox Your Description combo box should have the query as its recordsource so you don't have to run the query from the form. If you want to only check the first...
  5. A

    Setting a condition to open one form or another

    To add on to the last piece of advice, you state multiple criteria like this: If [DeceasedList].Column(4) = "Whatever" _ Or [DeceasedList].Column(4) = "SomethingElse" Then
  6. A

    Modify delete code-still need help

    My wife makes me put in these 'fail safe's all the time. Here you go: If MsgBox("Are you sure you want to delete this customer? " _ & "This action is not un-doable.", vbOKCancel, "Deletion Confirmation") _ = vbCancel Then MsgBox "No customer was deleted.", , "Action Canceled"...
  7. A

    Viewing specific data in a tab control

    When you create a listbox (NameOfListBoxHere), you have to specify which column is bound. You probably have it set for CustomerID. To open the form (NameOfFormHere), your best bet is to double-click on the customer in the listbox and set the On Dbl Click property to: DoCmd.OpenForm...
  8. A

    Need some serious HELP here.

    You may want to set the focus to that subform and refresh it: Forms![samplemainformname]![samplesubformname].Form.[sampletextbox].SetFocus Docmd.RunCommand acCmdRefresh
  9. A

    temp directory

    Let's say that your main table is called EmployeeTbl. You want to work on some information temporarily and then have it added to that table. In the tables section, hold down the Ctrl key and drag the EmployeeTbl (PermanentTable in my previous example) to a blank space in the section. This makes...
  10. A

    Hiding a button on a subform

    Something opens the form as either a form or a subform. Your best bet is to set the button's visibility with the procedure that opens it one of those ways.
  11. A

    How to code a Command button to display current form to a report

    Your best bet is to have your sub work off of a double click on one of the products. That way it knows exactly which ProductID is selected and you can then open the report with: DoCmd.OpenReport "rptDataComp", acPreview, , "[MixID]=[Forms]![frmDataComp]![MixID]" However, I recommend that you...
  12. A

    Create Select List Based on Results from Previous Field

    Have the recordsource for the Description combo box as a query. The query would have two main columns: Cost Type and Description. The first column would have a Criteria statement such as: Like Forms!yourmainform.CostTypeTextBox This would filter out all of the descriptions except for those...
  13. A

    Dlookup or otherwise, grabbing data

    The DLookup function gives you a value. You can do things with that value once it is calculated. To use your variables, the code would be =DLookup ("[StockPrice]","StockTable", "[StockID] = howeveryoupickthestockID"
  14. A

    temp directory

    Sure, I've done that. The trick is to create a parallel table (TempTable) to the one you eventually want to dump everything into (PermanentTable). Do all of your data work in the TempTable. Once you are ready to add it to your PermanentTable, run an Append Query from TempTable to PermanentTable...
  15. A

    Need some serious HELP here.

    You can always reference an open subform from anywhere using the following VB code example: Forms![samplemainformname]![samplesubformname].Form.[sampletextbox].value
  16. A

    Select exact record on date and time

    You need to set up your form recordset as a query. First, identify all records where the Eqpt ID = whatever you type in a text box in the form. Next, the date/time out is < the time you type in the form AND > the date/time in. You can build this in the design view of a query. Have a Refresh...
  17. A

    Select exact record on date and time

    You need to set up your form recordset as a query. First, identify all records where the Eqpt ID = whatever you type in a text box in the form. Next, the date/time out is < the time you type in the form AND > the date/time in. You can build this in the design view of a query. Have a Refresh...
  18. A

    Select exact record on date and time

    You need to set up your form recordset as a query. First, identify all records where the Eqpt ID = whatever you type in a text box in the form. Next, the date/time out is < the time you type in the form AND > the date/time in. You can build this in the design view of a query. Have a Refresh...
  19. A

    Back colour of command buttons

    You cannot change the back color of the Access command button even with code. It doesn't have that property. The trick is to grab some other button looking .gif, .jpg, or .bmp and paste it into the form. You can then put a transparent button on top of it and get the same effect. I've customized...
View older results
Back
Top Bottom