Menu
Home
Forums
New posts
Search forums
What's new
New posts
New profile posts
Latest activity
Members
Current visitors
New profile posts
Search profile posts
Log in
Register
What's new
Search
Search
Search titles only
By:
Current visitors
New profile posts
Search profile posts
Menu
Log in
Register
Home
Members
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Ranman256's latest activity
Ranman256
replied to the thread
Query Combo Box
.
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 ...
Yesterday at 1:59 PM
Ranman256
replied to the thread
Update and Save Main form from another form
.
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...
Wednesday at 1:04 PM
Ranman256
replied to the thread
How to avoid ms error message "You can't go to a specified record"
.
docmd.setwarnings false on error resume next
Tuesday at 5:46 PM
Ranman256
replied to the thread
What is the cheapest way to get the Ms Access installed on our system?
.
Beta? Access has been around for 30 years. No beta needed anymore.
Tuesday at 5:45 PM
Ranman256
replied to the thread
Copy multiple data from Cbobox to Textbox
.
the query behind the combo box should have 3 columns the combo property: column count= 3, either hide them or show them. (via...
Monday at 5:09 PM
Ranman256
replied to the thread
How you find duplicates but only just for the first 12 characters in a cell?
.
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!
Monday at 4:07 PM
Ranman256
replied to the thread
Image not printing out on reports sometimes
.
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...
May 20, 2022
Ranman256
replied to the thread
Data replacing each other - form based on query
.
set the form's textbox property: rowSource = tblStatus (the list to pick from) controlSource = (the field to save the status In the...
May 19, 2022
Ranman256
replied to the thread
How to use a SQL SELECT statement with Access VBA
.
Version 2 would be to use DLOOKUP to fill the text box. txtDescr= Dlookup(“description”,”table”,”[id]=“ & cboBox) no need to use sql.
May 18, 2022
Ranman256
replied to the thread
How to use a SQL SELECT statement with Access VBA
.
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...
May 18, 2022
Ranman256
replied to the thread
"The Text is too long to be edited"
.
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...
May 17, 2022
Ranman256
replied to the thread
MailMerge: Display Email before Send (wdSendToEmail)
.
comment out SEND and use DISPLAY: .Display True 'show user but dont send yet '.Send 'send now
May 17, 2022
Ranman256
replied to the thread
Button to open form and filter
.
don't use filter, so put 3 commas for the where: DoCmd.OpenForm "Clinic_Response", , , " [Item Code] = '" & Me.[Item Code1] & "' and...
May 17, 2022
Ranman256
replied to the thread
update query with multiple criterias
.
run 2 queries. don't cost nuthin.
May 13, 2022
Ranman256
replied to the thread
Runtime Error 3075 Debug stops on DoCmd.RunSQL SQL
.
run it as a query. Access will show you the errors. then use: docmd.openquery "qsMyQueryName" building error free sql takes too much...
May 13, 2022
Home
Members
Top
Bottom