Search results

I would like to be able to execute a basic command on an AS/400 through access I can achieve this through using activex controls, but I would like to do this through code so that I can tell it a username and password any ideas?

Hi, I have a form with a Client Access activex control button. using the button is no problem, but what I would like to achieve is to be able to perform the same function as the button but through code, does anyone know how I can do this?

for the criteria in the query for catagory name enter this [Forms]![form name]![CategoryName] then in the after update event use DoCmd.OpenReport "report name", acPreview to open the report

=DLookup("[CategoryName]", "tblProspects", "[CategoryID] =" & Reports![your report name]!CategoryID)

have u tried using DLOOKUP for the report field?

here's microsoft's long winded document about it http://support.microsoft.com/default.aspx?scid=/support/access/content/secfaq.asp

sorry to be a pain in the arse, but how can I use that through a query?

but how do I tell it that week 1 starts on 28/04/02 not on 01/01/02?

my works business calendar is split into week numbers is there an easy way that I can automatically (through an append query) add our given week numbers to dates that exist on tables which get the information from another machine. i.e. table with dates 11/10/02 12/10/02 13/10/02 would like...

txtSubTotal =[Forms]!

I needed to do similar, here's what I did set in code when something is typed into the first field, all exit buttons from the form are blocked (Enabled = False) then create a confirm button, when pressed the record is saved (and checks that all fields have been completed) and the exit buttons...

I like a challenge :p it's good to work through other peoples problems cause it'll probably happen to me next week!

phew

try this create a button on the first form, and use this code to make it open the second form to a blank record DoCmd.OpenForm "frmBlah" DoCmd.GoToRecord acForm, "frmBlah", acNewRec

change Dim pickDrug1 As String Dim pickForm1 As String Set pickDrug1 = Forms!ARTScript!pickDrug1 Set pickForm1 = Forms!ARTScript!pickForm1 DoCmd.GoToRecord , , acNewRec Forms!ARTScript!pickDrug1 = pickDrug1 Forms!ARTScript!pickForm1 = pickForm1 to Dim strpickDrug1 As String Dim...

you need to copy before you go to the new record

create the query then go to view menu then select SQL view.

I think that this will also change the date for the record that is currently selected

create a standard query and select all fields that you wish to display, then in the Criteria section for the field that you wish to search, simply enter what you would like it to find.

create an 'add new record' button on the form then play around with the code standard add new record code Private Sub AddNew_Click() On Error GoTo Err_AddNew_Click DoCmd.GoToRecord , , acNewRec Exit_AddNew_Click: Exit Sub Err_AddNew_Click: MsgBox Err.Description Resume...