Search results

You shouldnt be making system tables via VBA.

dont think that is possible. but why remove it?

copy can use either: sql method: update t.subtable set [field]= forms!fMasterform!listbox where [id]=forms!fMasterform!txtID or just copy value: me.subform.form.txtBox = forms!fMasterform!listbox

i have a textbox above the combo box to filter: txtFlt when user enters the filter string, switch source queries of the combo the query sql is like: qsFilterRecs = "select * from table where [Acct] like '*" & txtFlt & "*'" 'the AfterUpdate event for the filter: sub txtFlt_Afterupdate()...

I have checks in the entry form to make sure the user has entered correct data. Done on the form for easy changes, rather than have to edit the table properties. If IsValidForm() then SaveData Docmd.Close endif Private Function IsValidForm() As Boolean Dim vMsg Select Case True...

in excel, use Ctl-H to change values in Word, click MAILINGS, start mail merge mail merge wizard. it will guide you thru the steps and ask you to pick the Excel file that has the data.

in a SQL database, you dont cycle thru records using code. Use update queries. This will run it fast. cycling 1 records at a time is slow. join your source table to the target table on a unique field.

what about using: me.filter = "[ID]=" & cboBox me.FilterOn = true

did you use: Docmd.TransferText....? did that take an hour?

you can in a form, set the field property: ControlTipText Doesnt really work for reports.

if its autonum, then there should be no problem. Just save the record and the new key is generated. Its passive, nothing for anybody to do here.

they plug in a booster device in their electric socket. (available everywhere) Add your IP to the address.

you STILL must add that person's IP to the INTERNET OPTIONS, security tab, trusted sites. even tho youre not using internet, this allows you to use access on that pc.

do NOT put dlookups in queries. too slow. join the lookup table in yr query. use Dlookup in form field if needed when i has nothing to do with the query. =Dlookup([Field2Return], query, [where clause])

run append query : source data using source master form key, to target master key on form2 then refresh subform2

put a text box on the form with this datasource: =currentdb.Name

put your events in the autoexec when db starts: make macro AUTOEXEC runCode "MyPreProcedure" openForm "fLoginForm" but if mean run an app BEFORE they login to windows, then no. you cant. the code above lets you run the procedure then Login to your access app system.

Q1,select top 3 table1... Q2, Select top 3 table2... Q3, Select top 3 table3... Q4 union: select * from Q1 union select * from Q2 union select * from Q3

1. dont loop thru recordsets. slowest. 2. run queries. update or other

are you using someithing like: sFlt = "[ClientID]=" & me.cboClient docmd.OpenReport "rptName",acViewPreview ,sFlt better is: docmd.OpenReport "rptName",acViewPreview , , sFlt