Go Back   Access World Forums > Search Forums

Showing results 1 to 25 of 500
Search took 4.28 seconds.
Search: Posts Made By: Ranman256
Forum: Modules & VBA Today, 06:06 AM
Replies: 1
Views: 45
Posted By Ranman256
Re: AfterUpdate only editing first record

If it affects every sub record, then the query in the subForm should be using it.
Just refresh the query: me.subform.form.requery

Don't update 1 sub record at a time.
Forum: Reports Today, 06:02 AM
Replies: 2
Views: 36
Posted By Ranman256
Re: Group report background image problem

The pictures should be in the query on every record.
Each group has their pic.
In the report, add the pic image inside the detail or Group band header. It should change when the data changes.
Forum: Modules & VBA Today, 05:59 AM
Replies: 2
Views: 35
Posted By Ranman256
Re: Split form with more than one table/query

You can combine tables into 1 query.

But users can't really absorb info by looking at a thousand different items shown at once.
Make 1 button to see 1 table/query (list or single record)
Forum: Queries Today, 05:55 AM
Replies: 5
Views: 38
Posted By Ranman256
Re: Correct Quarrie Syntax Question

Drag the fields onto the query Grid,
Then add criteria under the field needed.
Forum: Forms Yesterday, 12:21 PM
Replies: 2
Views: 44
Posted By Ranman256
Re: how to detect if a sort has been applied using ac cmdfiltermenu

you don't need to detect a sort, just resort the way you want.
or apply another filter.
Forum: Reports 01-15-2019, 08:11 AM
Replies: 12
Views: 588
Posted By Ranman256
Re: Arranging exam register number data in zigzag order in ms access report

Don't know about zigzag,but in report page setup,
page setup, columns, either:

down, then across,
across, then down (aka zigzag?)
Forum: SQL Server 01-15-2019, 06:24 AM
Replies: 2
Views: 82
Posted By Ranman256
Forum: Modules & VBA 01-12-2019, 02:43 AM
Replies: 6
Views: 221
Posted By Ranman256
Re: Dirty records and how to correctly save the formīs changes to the underlying quer

I always remove the Me.Dirty.
it is more trouble than its worth.
Forum: Forms 01-12-2019, 02:41 AM
Replies: 10
Views: 311
Posted By Ranman256
Re: CSV Export File Programmatically

try not to use Drive letters for network files...instead use full UNC paths:
(but you can if you want)

vFile = "\\server\folder\Web_Reporting\Web_" & format(Date,"yyyymmdd")
Forum: Forms 01-10-2019, 12:46 PM
Replies: 4
Views: 261
Posted By Ranman256
Re: acCmdfiltermenu cascading issue

don't use GoToRecord. Show all records then filter them all.

build the 'where' clause by cycling thru all the combos....
it executes after a find button CLICK event
if null, ignore.
if not,...
Forum: Forms 01-10-2019, 09:00 AM
Replies: 4
Views: 202
Posted By Ranman256
Re: Filtering Forms on a checkbox

have the form show all records, but filter on the checkbox value

sub chkBox_Afterupdate()
me.filter = "[Field]=" & me.chkBox.value
me.filterOn = true
end sub

'default at load
Forum: Forms 01-10-2019, 02:58 AM
Replies: 4
Views: 148
Posted By Ranman256
Re: Multiple Combox use same list

Why use 8 combos to pick 8 items?, when you can use 1 combo to pick 8 items.
Forum: Forms 01-10-2019, 02:56 AM
Replies: 1
Views: 114
Posted By Ranman256
Re: Filter Menu blakc issue

don't GOTO 1 at a time, just filter all records.

me.filter = "[field]='" & txtBox & "'"
me.filterOn = true
Forum: Queries 01-10-2019, 02:53 AM
Replies: 3
Views: 263
Posted By Ranman256
Re: execute sql with textbox for date

I would use a query instead of SQL, it gets the syntax correct...
select * from table where [dtefld] = forms!myForm!txtDate

for sql , you don't need date delimeters for an update, but the...
Forum: Modules & VBA 01-09-2019, 12:43 PM
Replies: 2
Views: 172
Posted By Ranman256
Re: data change

what afterupdate? form?, field?

sub txtBox_Afterupdate()
If me.typeofentry = "new" then me.typeofentry = "old"
end sub
Forum: Modules & VBA 01-09-2019, 08:15 AM
Replies: 5
Views: 153
Posted By Ranman256
Re: loop through textbox with different criteria

Text boxes are for 1 entry.
Multiple items should be stored in a sub table,
1 item per record.
Forum: General 01-09-2019, 02:28 AM
Replies: 10
Views: 264
Posted By Ranman256
Re: Indexes in Access - when to use - modelling question

yes, it makes queries faster.
add one if the table has a unique identifier that you will search on.

a KEY field does this too.
like states table:
they are unique so when you key...
Forum: General 01-03-2019, 04:52 AM
Replies: 2
Views: 1,476
Posted By Ranman256
Re: Invalid Bracketing

hail the no space people!
Forum: Tables 01-02-2019, 05:38 AM
Replies: 2
Views: 401
Posted By Ranman256
Re: Employee Table

Wage should be its own table as a history, (tWageHist table)
empID, dateStart, Wage

the CURRENT wage can be on the tEmployee table.
there should be only ONE record of that John Smith in the...
Forum: Queries 12-28-2018, 05:54 AM
Replies: 5
Views: 282
Posted By Ranman256
Re: Finding portion of a string

in a query add these fields:

proj: left([jobnum],5)
task: mid([jobnum],6,3)
resource: right([jobnum],2)
Forum: Forms 12-27-2018, 07:08 AM
Replies: 4
Views: 233
Posted By Ranman256
Re: Multi Select Listbox

instead of multiselect list box, use a single listbox to add to a 'picked' table.
dbl-click runs append query to add item to the tPicked.
then the date check is just a query to validate.

Forum: Tables 12-27-2018, 04:06 AM
Replies: 2
Views: 280
Posted By Ranman256
Re: Oledb 12.0 provider does not support .index method

dont use seek, just filter the recordset.
Forum: Tables 12-26-2018, 12:15 PM
Replies: 4
Views: 464
Posted By Ranman256
Re: Subdatasheets on tables

nope. I never let users see them either.
They are more for the admin it view and see sub data.
Forum: Modules & VBA 12-21-2018, 08:57 AM
Replies: 5
Views: 380
Posted By Ranman256
Re: copying combobox selected value to form

so the user gives a filename, then what populates inside the combo?

can you have a table , with items the user can pick (the file) ,then in col2 (a query)
fill the cbo with that query?
Forum: Modules & VBA 12-21-2018, 06:15 AM
Replies: 5
Views: 380
Posted By Ranman256
Re: copying combobox selected value to form

why cant the combo be populated at the start?
Showing results 1 to 25 of 500

Forum Jump

All times are GMT -8. The time now is 11:59 AM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post

Sponsored Links

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World