Go Back   Access World Forums > Search Forums

Showing results 1 to 25 of 500
Search took 0.23 seconds.
Search: Posts Made By: Ranman256
Forum: Modules & VBA 09-17-2018, 03:03 AM
Replies: 7
Views: 110
Posted By Ranman256
Re: Print pdf files to "Adobe PDF" printer?

Can you just use:
Forum: Forms 09-17-2018, 03:02 AM
Replies: 4
Views: 83
Posted By Ranman256
Re: VBA Coding Error - Runtime Error

Try not to use long strings of vb to make SQL?
Instead use a query.
This helps you debug the Data type mismatch and other SQL errors.
Code does not.
Forum: Queries 09-16-2018, 10:57 PM
Replies: 2
Views: 115
Posted By Ranman256
Re: Duplicated records

your 3rd table has no duplicates.
it has the correct product.
Forum: Modules & VBA 09-14-2018, 10:53 AM
Replies: 15
Views: 226
Posted By Ranman256
Re: Access VBA not changing Word Font.Color

it may not know what 'wdColorRed' is.
use: = vbRed
=255 (same as wdColorRed)
Forum: Forms 09-14-2018, 08:18 AM
Replies: 10
Views: 172
Posted By Ranman256
Re: Need subreport on form to show one record

Dragging the table to the form doesn't do it all.
You must set the property of the subForm to show only that master key.
Set subForm properties:
Master form field,
Child form field

Forum: Forms 09-14-2018, 06:43 AM
Replies: 4
Views: 69
Posted By Ranman256
Re: Expression not working on tab form

this should work, providing your text box names are correct.
(the text box name may not be the same as the field name, but they can)

by the look, these are multiple records? If so, why are there...
Forum: Forms 09-13-2018, 09:04 AM
Replies: 12
Views: 126
Posted By Ranman256
Re: Can't edit fields in form

is the query a snapshot?
is the form set to locked?
are the text boxes set to locked?
does the query have joins to other tables? (this can be Read Only)
Forum: Modules & VBA 09-13-2018, 02:31 AM
Replies: 6
Views: 171
Posted By Ranman256
Re: Copy files based on listbox selection

dim sSrc as string, sTarg as string, sName as string
dim vDir

'text box holds the target folder
vDir = txtTargetFolder
If Right(vDir, 1) <> "\" Then vDir = vDir & "\"

For i = 0 To...
Forum: Reports 09-12-2018, 06:37 PM
Replies: 2
Views: 109
Posted By Ranman256
Re: How do you fill out a table based reports ?

Set the property to landscape in design mode.
Then print to PDF:
Docmd.output ....
Forum: General 09-12-2018, 05:54 AM
Replies: 15
Views: 747
Posted By Ranman256
Re: Multiple users

are these databases split?
you cant really use them unless you have them split on the network.
Forum: Modules & VBA 09-12-2018, 05:53 AM
Replies: 4
Views: 83
Posted By Ranman256
Re: Check for Duplicates

couldnt you just enter codes into a keyed table? Thus preventing duplicates.
No code needed.
Forum: Queries 09-10-2018, 05:41 PM
Replies: 2
Views: 98
Posted By Ranman256
Re: Enter Password for Select in

Use a linked table.
Forum: Reports 09-10-2018, 01:47 PM
Replies: 2
Views: 111
Posted By Ranman256
Re: Open report with groups hidden

Make report form.
Pick a report from a listbox,bound to table tReports.
RptCaption, Report

The listbox would show the caption but the 2nd column is bound to the box.
Then a button to open the...
Forum: Forms 09-10-2018, 05:47 AM
Replies: 25
Views: 314
Posted By Ranman256
Re: Pick Record from certain record for a parameter query

the query must have the record Key in it:
select * from table where [key]=forms!myForm!txtKey

you can also open a form on that record:
docmd.openForm "fMyForm",,,"[key]=" & me.txtKey

does the...
Forum: Forms 09-09-2018, 11:56 PM
Replies: 12
Views: 166
Posted By Ranman256
Re: Passing data from one form to another

did you use the BUILDER to get these path names?
always use the builder, it never gets the path wrong.

usu, the path is like:
Forum: Forms 09-06-2018, 09:42 AM
Replies: 4
Views: 135
Posted By Ranman256
Re: Add New record Issue

append query. To add items in 1 form/table to the target table.
Forum: General 09-06-2018, 07:34 AM
Replies: 7
Views: 515
Posted By Ranman256
Re: Workaround Networking Interruptions in Split Databases

Fix your network. It should not loose connection.

You could try not have any forms direct connect to the data.
Use an bound form to a local table, enter data,run an append query.
This way the...
Forum: Forms 09-06-2018, 05:03 AM
Replies: 7
Views: 174
Posted By Ranman256
Re: Calendar chart

you need X.
make a query that has the X and Y values.

format([dateFld],"yyyy-mm") as X
Forum: Modules & VBA 09-06-2018, 01:05 AM
Replies: 3
Views: 95
Posted By Ranman256
Re: DCount to decide

using OPTION EXPLICIT will catch these errors the eye may not.
Forum: General 09-06-2018, 01:03 AM
Replies: 4
Views: 402
Posted By Ranman256
Re: URGENT HELP , Filter report with two criteria with Macro

instead of using macro, use vb.
in the button to open the report, filter the report here:

sub btnReport_click()
dim sWhere as string

sWhere = "1=1"
Forum: Macros 09-05-2018, 04:54 AM
Replies: 2
Views: 128
Posted By Ranman256
Re: Iterate a macro more than 20 times

can you use a macro, to run a macro,
command: RUN MACRO
and set the REPEAT COUNT = 40 (or your #)

(no VB needed)
but if you want VB, make a form with a text box to put the repeat #:

for i =...
Forum: General 09-04-2018, 08:19 AM
Replies: 2
Views: 259
Posted By Ranman256
Re: Backup file name?

no, it tries to write to Database_Backup again.
you either overwrite it, or give a new name.

in the file explorer, search BACKUP,
press delete key.
Forum: Modules & VBA 09-04-2018, 03:29 AM
Replies: 9
Views: 155
Posted By Ranman256
Re: Run Time Error '3134' - Syntax Assistance Required

Have you trie using a query instead of code?
Queries tell you what is wrong.
Forum: General 09-03-2018, 07:34 AM
Replies: 6
Views: 381
Posted By Ranman256
Re: Multi Listbox

Instead of using multi select list box, which requires programming,
You could use a single select list,dbl-click the item,which adds the item to a 'tPicked' table.
(Via append query)
Then just...
Forum: General 08-31-2018, 10:39 AM
Replies: 10
Views: 434
Posted By Ranman256
Re: I Need your urgent support . Validation Rule and VBA Code

instead of validation rule, put code in the form, so users cannot edit if theres a ClearanceCode:

sub form_OnCurrent()
txtAcctNum.locked = not IsNull(txtClearCode)
end sub

user wont be...
Showing results 1 to 25 of 500

Forum Jump

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