Go Back   Access World Forums > Search Forums

Showing results 1 to 25 of 500
Search took 0.14 seconds.
Search: Posts Made By: Ranman256
Forum: Forms Today, 12:22 PM
Replies: 1
Views: 39
Posted By Ranman256
Re: VBA code to append data

append query.
either link the xl file as an external table then run append query
run the transfer :
docmd.TransferSpreadsheet acImport ,acSpreadsheetTypeExcel12,sTable, sFile, true,sSheetName
Forum: Modules & VBA Today, 05:16 AM
Replies: 2
Views: 144
Posted By Ranman256
Re: Import multiple .csv

after import, set the null FILENAME field

Public Sub btnImport_click()
ImportFilesInDir "c:\myfolder\folder\"
end sub

Public Sub ImportFilesInDir(ByVal pvDir)
Dim FSO, oFolder, oFile,...
Forum: Queries Today, 05:05 AM
Replies: 4
Views: 361
Posted By Ranman256
Re: Access 2016 Using combobox in SQL query

instead of using the combo in the query, just filter the records.
show all records in the form, then when user picks one :

sub cboBox_Afterupdate()
If IsNull(cboBox) Then
Me.FilterOn =...
Forum: Modules & VBA 11-16-2018, 05:41 AM
Replies: 13
Views: 460
Posted By Ranman256
Re: Rename files based on recordset names

the name of the QUERY,
or the name of the FORM?
(still not a recordset)

you use both nomenclatures in your reply.
Forum: General 11-16-2018, 05:40 AM
Replies: 18
Views: 221
Posted By Ranman256
Re: Refer and filter one subform as datasheet to another subform

do mean like a form-subfrom-subSubForm

where selecting item in subForm1 filters subForm2?
like 3 deep forms.
This seems to be your solution. I use this.
Forum: Access Web 11-16-2018, 01:02 AM
Replies: 2
Views: 580
Posted By Ranman256
Re: Show label Name at Text box

when you put a text box on the form, it comes with a label.
if you dont have one, copy one on the form, select the text box, paste.
if you dont have any labels, click the label tool, put it on the...
Forum: Reports 11-15-2018, 10:35 AM
Replies: 6
Views: 129
Posted By Ranman256
Re: Enabling a subreport from form

is the code above for the 10 reports? If so, you need do nothing if run from another form.
the subreport should be visible.
you can have 2 reports,
save AS and have the subrpt visible, and...
Forum: Modules & VBA 11-15-2018, 07:29 AM
Replies: 13
Views: 460
Posted By Ranman256
Re: Rename files based on recordset names

when it loops thru the files in the folder,
it gets the source name,
but where is this target name: Recordset.title?

theres no rst needed for file rename.
is it the current recordset you are...
Forum: Forms 11-15-2018, 06:58 AM
Replies: 21
Views: 370
Posted By Ranman256
Re: [Form] Can I press a button to run 2 queries?

these commands do not use OLE, nor ActiveX controls.
Forum: General 11-15-2018, 06:57 AM
Replies: 3
Views: 132
Posted By Ranman256
Re: Excel running Access VBA

theres another object needed:

With a
with .Application
.DoCmd.OpenForm "myForm
.DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "myTable", strTempFile, True...
Forum: Queries 11-15-2018, 05:37 AM
Replies: 12
Views: 319
Posted By Ranman256
Re: Query for Cascading Combo Boxes

if the combo is bound to the ID, then the combo1 MUST use ID.
States dont need an ID field, since they are unique.
Forum: Forms 11-15-2018, 03:08 AM
Replies: 2
Views: 102
Posted By Ranman256
Re: How to set focus back on a form

tell yr boss to enter the 21st century and stop killing trees.
you can produce a pdf, 'a digital paper'.

the openReport should never leave the form....it sends it to the printer.
recall the open...
Forum: Forms 11-15-2018, 02:58 AM
Replies: 21
Views: 370
Posted By Ranman256
Re: [Form] Can I press a button to run 2 queries?

sub btnGo_click()
docmd.openquery "query1"
docmd.openquery "query2"
end sub


sub btnGo_click()
Forum: Queries 11-15-2018, 02:55 AM
Replies: 12
Views: 319
Posted By Ranman256
Re: Query for Cascading Combo Boxes

combo 2 source uses combo1 as criteria in the query
but you must refresh combo2 when combo1 is chosen....

cboStates has all state names. When user picks a state, the cboCity must be refreshed...
Forum: General 11-15-2018, 02:53 AM
Replies: 1
Views: 170
Posted By Ranman256
Re: Read Pdf file into form

you do NOT want to load pdf into a form. it looses detail.
just open it in its own window:

paste this code into a module. (Alt-F11, insert , module)
Then it will open ANY file via its...
Forum: Queries 11-14-2018, 11:59 PM
Replies: 1
Views: 98
Posted By Ranman256
Re: Change query data

access doesnt really create data that way.
Not with 2 columns.
Crosstab queries require 3.
Forum: General 11-14-2018, 01:29 AM
Replies: 18
Views: 375
Posted By Ranman256
Re: .datawait file type

Public Sub ScanSubfolders()
Dim FileSystem As Object
Dim HostFolder As String

HostFolder = "G:\Documents\DIY\"

Set FileSystem = CreateObject("Scripting.FileSystemObject")...
Forum: General 11-14-2018, 01:00 AM
Replies: 18
Views: 375
Posted By Ranman256
Re: .datawait file type

did you try to rename a file and remove the '.datawait' and see if the file worked ok?
if so, you can use the code to rename all files to remove the .datawait.
(coming soon)
Forum: Forms 11-14-2018, 12:57 AM
Replies: 1
Views: 100
Posted By Ranman256
Re: Filter query based on combo box selection

in the combo box AFTERUPDATE event:

sub cboBox_Afterupdate()
If IsNull(cboBox) Then
Me.FilterOn = False
Me.Filter = "[CCode]='" & cboBox & "'"
Me.FilterOn = True
End If
Forum: General 11-13-2018, 02:45 AM
Replies: 2
Views: 128
Posted By Ranman256
Re: Novice - Which way to turn

basically, just 1 table, tLogs, (or your name here)

shift, personID, EVent, EventDate

(note EventDate is date and time)
then you can sum up events by the date, hour, by person, by Shift.
Forum: General 11-13-2018, 01:13 AM
Replies: 17
Views: 242
Posted By Ranman256
Re: Query Criteris - Searching for Text in String

create a table, called tPicked.
enter (1 per cell) all the values you want to search for.
join this table to your data table on the common field.
run the query, only those values will return.
Forum: Reports 11-12-2018, 01:47 PM
Replies: 2
Views: 283
Posted By Ranman256
Re: Report to show incremental count

in the query, add a column: 1
this is the counter,
in the report, add this field, set to RUNNING SUM = TRUE
put a label after the box: "of 4"

then when the report prints, it will read:
1 of 4...
Forum: General 11-12-2018, 06:59 AM
Replies: 11
Views: 276
Posted By Ranman256
Re: Multiple list boxes as report parameters

using that many listboxes....
it will take a lot of code to create the where.

it may be faster/easier just to show the user everything, and let them ,right-click filter on fields they want to see.
Forum: Modules & VBA 11-11-2018, 02:36 AM
Replies: 3
Views: 112
Posted By Ranman256
Re: send file by mail VBA

remove the:
Forum: General 11-09-2018, 11:49 PM
Replies: 1
Views: 172
Posted By Ranman256
Re: CC on email

cycle thru the email list, collect the names, then put list in the .TO property:

in a form is a listbox
the list is a query of the names to send to
this cycles thru the list, collects the names,...
Showing results 1 to 25 of 500

Forum Jump

All times are GMT -8. The time now is 07:54 PM.

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

Sponsored Links

How to advertise

Media Kit

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