Go Back   Access World Forums > Search Forums

Showing results 1 to 25 of 500
Search took 0.71 seconds.
Search: Posts Made By: Ranman256
Forum: General Today, 03:23 AM
Replies: 4
Views: 60
Posted By Ranman256
Re: User cannot start Access database

Is this a SPLIT database?
Forum: Queries 03-22-2019, 12:14 AM
Replies: 8
Views: 103
Posted By Ranman256
Re: Reset Rank column in MS Access query every year

you can do it in a report.
in the query make a constant field: Rank= 1
in the report, add the GROUP band for DDATE
add Rank & Date on the report detail: RANK , DDATE
select the RANK field, show...
Forum: Forms 03-21-2019, 10:25 AM
Replies: 6
Views: 114
Posted By Ranman256
Re: Make data entry depending on which button is clicked

each button would have its own code:

sub btnWeld_click()
docmd.openform "frmWeld", , , , acFormAdd
forms!frmWeld!txtInspectType =2
end sub

or use 1 form for all , and pick the...
Forum: Queries 03-21-2019, 09:14 AM
Replies: 3
Views: 93
Posted By Ranman256
Re: Expression Hides Query From Excel

Excel cant understand some queries. This is one.
make 3 subQueries,

then put them all into a UNION query
select * from Q1
select * from Q2
Forum: Reports 03-20-2019, 05:23 AM
Replies: 7
Views: 103
Posted By Ranman256
Re: PDF as Template

you need to design it (form or report) from scratch.
then :
docmd.OutputTo acOutputReport ,sRpt ,acFormatPDF, sFilename
Forum: Forms 03-20-2019, 05:20 AM
Replies: 6
Views: 91
Posted By Ranman256
Re: Form filter using multiple values in a control

build the 'where' clause by cycling thru all the controls....
it executes after a find button CLICK event
if null, ignore.
if not, apply.

sub btnFilter_click()...
Forum: Reports 03-19-2019, 09:45 AM
Replies: 4
Views: 84
Posted By Ranman256
Re: Report - 2501 Error

use a form, with textboxes.
have the report query read these boxes as field in the query,
select forms!myForm!txtCustomer as Cust from table

report on these fields.
Forum: Modules & VBA 03-19-2019, 03:43 AM
Replies: 2
Views: 72
Posted By Ranman256
Re: Expresssion on click event

This usu happens because the error is in a property.
The compile won't find it since its not in the code modules.

These are the HARDEST to find since you must investigate EACH property setting...
Forum: Reports 03-18-2019, 04:16 PM
Replies: 3
Views: 102
Posted By Ranman256
Re: Linked File Date and Time

If the xl file is linked, add this code to a module,
then submit the name of the table to get the date of the file linked to it.
put this in a text box, and run a query/report using the text box...
Forum: Queries 03-18-2019, 12:11 PM
Replies: 3
Views: 93
Posted By Ranman256
Re: Search function for continuous form keeps asking me to "Enter Parameter Value"

the query may have a param in it ,either:
a misspelled field name, or one that does not exist.

if you are giving params via code, then you must add them to the code

dim qdf as querydef
Forum: SQL Server 03-18-2019, 11:36 AM
Replies: 15
Views: 217
Posted By Ranman256
Re: Sql Server Migration Assistant - Front-End Access

you should only need to relink 1 FE, then distribute it to all.
Forum: Forms 03-18-2019, 09:08 AM
Replies: 7
Views: 98
Posted By Ranman256
Re: Formatting different in form compared to table

formatting is independent.
just like a query sort wont work in a report unless you set it in the report.
Forum: Reports 03-18-2019, 05:18 AM
Replies: 3
Views: 92
Posted By Ranman256
Re: Applying Filter to Report & All Bound Children on Report

Don't put quotes around the form object....

If numeric:
SFilter= "[field]=" & forms!myform!txtBox

If string,
SFilter= "[field]='" & forms!myform!txtBox & "'"
Forum: Reports 03-17-2019, 05:16 AM
Replies: 3
Views: 112
Posted By Ranman256
Re: Calculation within the report

Put the calculations in the query.
Summations in the report footers.
Forum: Forms 03-16-2019, 12:37 AM
Replies: 3
Views: 82
Posted By Ranman256
Re: Identify subform controlsourve

use the BUILDER...it gets the paths correct.
usu: forms!fMasterFrm!SF1.form.txtFld

but you shouldn't be linking 1 subform to another subform,
subforms link to the master form
Forum: Queries 03-15-2019, 07:16 PM
Replies: 5
Views: 107
Posted By Ranman256
Re: Rank business days

the rank looks a simple ascending date.
(set unique values = true)

select DISTINCT Date from table
Forum: Forms 03-15-2019, 10:48 AM
Replies: 31
Views: 354
Posted By Ranman256
Re: Records in combo box catch22

you should have another query, qsAllItems
(current and discontinued)
to use for reporting purposes.

the qsActiveItems, (where Discontinued = false) is for the combo.
tho Items.[Is Discontinued]...
Forum: Modules & VBA 03-15-2019, 09:04 AM
Replies: 6
Views: 147
Posted By Ranman256
Re: Runntime Error 3464

put a stop point on the red line,
then when code stops, hover cursor over: sActiveUser
I bet that it came back null.

get the active user ID via:
vUserID = Environ("Username")

then look ...
Forum: General 03-15-2019, 12:12 AM
Replies: 11
Views: 162
Posted By Ranman256
Re: lookup

in the combo drop box, have it use 2 columns:

then in the cboBox afterupdate event, just fill in from the 2nd column.
NOTE: in vb, columns begin with zero

Forum: General 03-13-2019, 09:30 AM
Replies: 10
Views: 198
Posted By Ranman256
Re: Adding items to general context menu (not on a form!)

its easier to just build a menu. (buttons on a form)
you could enable buttons based on user ID.
Forum: General 03-13-2019, 07:03 AM
Replies: 2
Views: 95
Posted By Ranman256
Re: Export Access table to RSS feed

you export tables to a file.
you pick the format,
tho RSS should read from available formats?
Forum: VB.NET 03-13-2019, 12:16 AM
Replies: 2
Views: 89
Posted By Ranman256
Re: How do i send a TLS mail using VB.net (Need an free easendmail alternative)

try SENDOBJECT,(in access)
docmd.SendObject acSendReport ,"rMyReport",acFormatPDF,sTo,,,sSubj,sBody
docmd.SendObject acSendQuery ,"qsMyQuery",acFormatXLS,sTo,,,sSubj,sBody

OR usu there is a .dll...
Forum: Modules & VBA 03-12-2019, 05:49 PM
Replies: 14
Views: 242
Posted By Ranman256
Re: Form data, create PDF(s) and e-mail

in a form is a listbox
the list is a query of the name to send to
this cycles thru the list, collects the names, then sends the report
text boxes hold the report name, email body, and subject

Forum: Modules & VBA 03-11-2019, 11:19 AM
Replies: 4
Views: 94
Posted By Ranman256
Re: sintax error

something in the query wants a parameter filled in.
either a form reference,
or instant param field: [param enter here]
or a misspelled fieldname

if the query DOES need a param filled, then...
Forum: Forms 03-11-2019, 07:40 AM
Replies: 3
Views: 72
Posted By Ranman256
Re: Prevent toggle true if another field is empty

In the ON CURRENT event:

Toggl.enabled =not IsNull(me.txtBoxFld)

You might want this in the afterupdate too,if the user fills in the field so toggle can turn on.
Showing results 1 to 25 of 500

Forum Jump

All times are GMT -8. The time now is 12:38 PM.

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