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,
<=15
15-36
>36

then put them all into a UNION query
select * from Q1
union
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
dim...
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:
CODE, SUPPLIERNAME

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


sub...
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
General
Tables
Queries
Forms
Reports
Macros
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