Search results

in the AFTERUPDATE event of the combo, put that column value into a hidden text box. Then the query can read the textbox. 'in VB , columns begin with zero, so column 2 is: cboBox.column(1) sub cboBox_Afterupdate() txtBox = cboBox.column(1) end sub query: select * from table where...

do you want to save data or requery? 1 saving data is automatic. Use can leave the record or the form and data saves. also the command: DoCmd.RunCommand (acCmdSaveRecord) will save the record. 2. if this code is in '"Import Material"' form, it wont run since the form got closed ,thus no...

docmd.setwarnings false on error resume next

Beta? Access has been around for 30 years. No beta needed anymore.

the query behind the combo box should have 3 columns the combo property: column count= 3, either hide them or show them. (via columnwidths) then in the AFTERUPDATE of the combo, fill the text boxes. Note: in VB, columns begin with zero sub cboBox_Afterupdate() txtID = cboBox.column(0)...

make a query with MINTY's field, say Q1, then use the query wizard, to make FIND DUPLICATES QUERY, choose Q1 as the source. voila!

There is also a bug using Win64 & Access32 on some PC's, SOMETIMES the image will show, others it wont. Usu re-installing Paint will solve it.

set the form's textbox property: rowSource = tblStatus (the list to pick from) controlSource = (the field to save the status In the current record), ...StatusName (if I understand you)

Version 2 would be to use DLOOKUP to fill the text box. txtDescr= Dlookup(“description”,”table”,”[id]=“ & cboBox) no need to use sql.

You don’t need sql. Use a combo box Connected to that table. set the combo property to have 3 columns. in the combo AFTERUPDATE event, load the 3rd column (Note, in vb , columns begin with zero) txtDescr= cboBox.column(2). that’s the only line of code you need.

DO NOT build IFs in sql. build a table (a lookup table) with these codes. Join the table to your data and this will convert them for you without using IF.

comment out SEND and use DISPLAY: .Display True 'show user but dont send yet '.Send 'send now

don't use filter, so put 3 commas for the where: DoCmd.OpenForm "Clinic_Response", , , " [Item Code] = '" & Me.[Item Code1] & "' and [Clinics_Location] = " & Me.Location_Code

run 2 queries. don't cost nuthin.

run it as a query. Access will show you the errors. then use: docmd.openquery "qsMyQueryName" building error free sql takes too much time.

cant you just click the DELETE button on the keyboard?

Queries make calculated fields, not tables. the table holds the fields to do the calc.

Make a form that shows all records, user can filter , add button to open that selected record via the key to view the 1 record... docmd.openform “fDetail”,,”[id]=“. & me.txtID

what version of Outlook? Older Outlooks have this message to prevent evil code running it. you may have to send it in access via outlook code, make pdf file, then send via email: 'NOTE : YOU MUST HAVE THE OUTLOOK REFERENCE CHECKED IN VBE; Alt-F11, menu,tools, references, Microsoft Outlook XX...

select DateDiff("d",[DepartArmyDate],Date()) as DepartDays, DateDiff("d",[LeaveDutyStationDate],Date()) as LeavStationDays from table then you can filter