Go Back   Access World Forums > Search Forums

Showing results 1 to 25 of 500
Search took 0.40 seconds.
Search: Posts Made By: Ranman256
Forum: Modules & VBA 05-17-2019, 10:58 AM
Replies: 1
Views: 110
Posted By Ranman256
Re: Button for Due Dates

in a form put a box ,txtDays. fill it with 30, 60,etc.
in the query to pull data, use the form to get the time range.

all those who's [due date] < N days
select * from table where...
Forum: Reports 05-14-2019, 11:03 PM
Replies: 2
Views: 63
Posted By Ranman256
Re: Looping help with report

don't 'loop thru' , DO run an update query,
change status to closed.

docmd.openquery "quSetStatusClosed"
Forum: General 05-07-2019, 02:13 AM
Replies: 8
Views: 234
Posted By Ranman256
Forum: Forms 04-20-2019, 06:05 PM
Replies: 4
Views: 73
Posted By Ranman256
Re: Subtotal formula in Subform

in the subform footer, add a field with the formula:
Forum: Queries 04-18-2019, 01:59 AM
Replies: 2
Views: 81
Posted By Ranman256
Re: Query to show values that apear in one table but not another

you want an OUTER join.
in query, bring in both tables,
join on CustCode,
dbl-click the join line,
set to : show ALL records in tbl1, SOME recs in tbl2
bring in CustCode from both tables onto...
Forum: General 04-16-2019, 04:24 AM
Replies: 8
Views: 190
Posted By Ranman256
Re: Dynamic query execution option

just run the query selected in the list

sub btnRun_click()
docmd.openQuery lstbox
end sub
Forum: Theory and practice of database design 04-16-2019, 12:34 AM
Replies: 3
Views: 134
Posted By Ranman256
Re: FE/BE Installation

in menu , Database Tools, click Access database,
click split database button.
afterwards, I rename my BE : myDbName_BE.accdb
move the BE to the server folder.
open the FE, frontend.
Forum: Forms 04-15-2019, 01:02 AM
Replies: 13
Views: 247
Posted By Ranman256
Re: Sync field from one tabbed form to another tabbed form.

with this schema:

tPurch Tbl
PurchID, PurchDate, VendorID
1 4/15/2019 123

tPurchDtl table
PurchID, Item Qty, Price ,etc
1 Pens 3
Forum: Other Software 04-14-2019, 05:27 AM
Replies: 1
Views: 92
Posted By Ranman256
Re: Investment Property Software

I would be similar to the Property Rental db.
grab an example.
You could modify to fit your needs.
Forum: General 04-11-2019, 11:12 AM
Replies: 10
Views: 344
Posted By Ranman256
Re: Help file generator (was TonyE)

I just make a word document or Pdf.
Forum: Forms 04-10-2019, 01:41 AM
Replies: 2
Views: 191
Posted By Ranman256
Re: copying files from "filelist" to destination folder

in access, lists are controlled by a table.
the list is bound to it

so instead of using: Me.filelist.AddItem
make an append query:

insert into table (filename) values ('" & varFile & "')"...
Forum: Modules & VBA 04-09-2019, 05:26 PM
Replies: 1
Views: 205
Posted By Ranman256
Re: Help With Validation on a combo box based on the values of other combo boxs in a

make another table that has the conditions , say: tCallRisk

Overall Fail, No High Risk
Overall Fail , No Medium Risk

then combo1 would be Call Details
after user picks it, then combo2...
Forum: Modules & VBA 04-09-2019, 06:30 AM
Replies: 6
Views: 271
Posted By Ranman256
Re: Split by Commas and add to new table

paste the code into a module ,
setup your source & target tables,
then run ParseCommaFlds

'take a field with codes that are comma delim, and break up into single records.
Public Sub...
Forum: Reports 04-09-2019, 06:10 AM
Replies: 13
Views: 304
Posted By Ranman256
Re: Call report form a Form

the code is correct for the where clause, if
ID is the name of the field AND the name of the text box
ID has a value.

Try print preview before you send to printer:

preview string field:...
Forum: Forms 04-08-2019, 10:33 AM
Replies: 3
Views: 131
Posted By Ranman256
Re: Report from Continuous form

the report should be based on a query (same as the form)
if the query pulls 9 records, so will the report.
Forum: Forms 04-08-2019, 05:51 AM
Replies: 17
Views: 455
Posted By Ranman256
Re: How can I update one subform with information from another subform?

an update query, using the key from the source subform.

update tbl2 set tbl2.field = tbl1.value where tbl1.key = forms!fMasterFrm!subform1.form.key1
Forum: The Watercooler 04-06-2019, 04:51 AM
Replies: 14
Views: 510
Posted By Ranman256
Re: S-Q-L or SEQUEL?

both. like:
koo-pon & Qpon.
caramel, Kar-mel
On-velope, En-velope
Forum: General 04-05-2019, 10:18 AM
Replies: 2
Views: 125
Posted By Ranman256
Re: Inward and Outward mail MS Access database

for importing data, create a macro in Outlook to take the selected mail item to import the data in the body,or attachment into access.

for sending email , just make a query and send it via:...
Forum: Modules & VBA 04-04-2019, 01:05 AM
Replies: 6
Views: 139
Posted By Ranman256
Re: Opening a new Email from Access

The vb code controls Outlook.
Outook controls the email. (And SMTP)
Forum: Queries 04-04-2019, 01:03 AM
Replies: 3
Views: 170
Posted By Ranman256
Re: Access 2010 to 2013 UNION ALL

There should be no difference. SQL is the same in all versions.
Now, it's possible a link may have broken,
Or a function reference got broken due to the upgrade.

Check VBA references: alt-f11,...
Forum: Excel 04-03-2019, 01:01 PM
Replies: 7
Views: 216
Posted By Ranman256
Re: total every 20 employees

How do you calculate an employee?
you want any 20?
the 1st 20?
Pick random 20?
Forum: Reports 04-03-2019, 06:19 AM
Replies: 2
Views: 148
Posted By Ranman256
Re: Sum on a report

I add an extra column ,say Header: 'My Report'
make it the outer most grouping ,
sum the Grand Total in this.
Forum: Forms 04-03-2019, 06:15 AM
Replies: 23
Views: 368
Posted By Ranman256
Re: Help with Order form design

you need a tParts table. Its a lookup table the user can pick via listbox,
or combo box in the OrderDtl subform.
picking the part will add the PartDescr, Price, Vendor too.

if combo box method,...
Forum: Modules & VBA 04-03-2019, 05:00 AM
Replies: 5
Views: 146
Posted By Ranman256
Re: dates issue

You need another field,OrigDate to hold it,
In a form ,hold the orig date in another text box. Restore from that.
But once you leave the form, the orig date is gone.
I don't know how long you...
Forum: General 04-03-2019, 03:06 AM
Replies: 9
Views: 242
Posted By Ranman256
Showing results 1 to 25 of 500

Forum Jump

All times are GMT -8. The time now is 01:58 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