Go Back   Access World Forums > Search Forums

Showing results 1 to 25 of 500
Search took 0.29 seconds.
Search: Posts Made By: Ranman256
Forum: General Today, 06:02 AM
Replies: 4
Views: 52
Posted By Ranman256
Re: Access db "pings" and displays hourglass circle at odd times

never seen such a thing happening on a local drive.
Forum: Modules & VBA Today, 03:42 AM
Replies: 5
Views: 56
Posted By Ranman256
Re: Report Print event?

when the preview report shows, the form IS hidden. It is behind the report.
Close the report, you see the form again. Nothing more needs done.
Forum: Modules & VBA 12-13-2017, 09:18 AM
Replies: 4
Views: 117
Posted By Ranman256
Re: Reformatting data fron one table to a new table

begin a select query,
drag the fields from the source table and put on query line
add any calculated fields ,and constants , ie:
MyState: OH
Speed: [dist]/[time]

now you can export this...
Forum: Queries 12-12-2017, 07:25 AM
Replies: 14
Views: 166
Posted By Ranman256
Re: Records not matching with Criteria

is [Preferred] as string field or a boolean Y/N field?
Forum: Queries 12-12-2017, 03:48 AM
Replies: 3
Views: 104
Posted By Ranman256
Re: Auto-populating invoice number into a certain field

the field autonum is a great idea to use as Invoice#. It is created automatically.
the user does nothing, there is zero programming.
but, if you want to put more work into this, if you are...
Forum: Modules & VBA 12-11-2017, 07:19 AM
Replies: 13
Views: 177
Posted By Ranman256
Re: Dcount in field on form

the 3rd param of Dcount is the filter, so if you only want 1 officer in query:"July2017Query", then:

count1 = DCount("officer1Lookup", "July2017Query","[officerID]=" & txtBox)
Forum: Excel 12-11-2017, 03:47 AM
Replies: 3
Views: 132
Posted By Ranman256
Re: displaying udf parameters when called from excel cell

parameters do not normally appear in the cell.
Forum: Queries 12-08-2017, 10:45 AM
Replies: 4
Views: 103
Posted By Ranman256
Re: query only one list element in multiple lookup field (with multiselect listbox)

your table is not designed correctly. Its not normalized.
Alumni.Staffers2 field should only contain 1 name in the field
if you want multiple names for this 1 alumnus, then Staffers2 field should...
Forum: Site Suggestions 12-08-2017, 10:01 AM
Replies: 10
Views: 186
Posted By Ranman256
Re: How to post an image?

click GO ADVANCED button
use the paperclip, attach pic, load it
come back to message box, click paperclip downarrow, select the pic.

if paperclip fails, use button under MANAGE ATTACHMENTS.
Forum: Modules & VBA 12-08-2017, 04:29 AM
Replies: 6
Views: 166
Posted By Ranman256
Re: get results from query and put them into one line of text

something like:

Public Sub btn_test_Click()
Dim rs As DAO.Recordset
dim vLine

Set rs = CurrentDb.OpenRecordset("qry_profile_1_scr2_results")
' print column names
'Dim i As Integer
Forum: Modules & VBA 12-07-2017, 10:15 AM
Replies: 2
Views: 127
Posted By Ranman256
Re: Is there any way to export object query with current date

export the reg. query to a file with the date:

vFile = "c:\folder\VdrDeliveredtoDock" & Format(Date, "MMM-DD-YYYY") & ".xlsx"
docmd.TransferSpreadsheet acExport...
Forum: Forms 12-07-2017, 08:49 AM
Replies: 8
Views: 197
Posted By Ranman256
Re: Errors when processing events

If the form is processing code, users should not be able to exit.
What kind of errors?
Forum: Modules & VBA 12-07-2017, 08:47 AM
Replies: 6
Views: 170
Posted By Ranman256
Re: enable textboxes if three criterias met in table

i have userpermissions too.
when the form loads, in the LOAD event, you turn on/off items based on permission:

btnAdmin = userpermissions ="A" (admin)
txtSocSec.visible = userpermissions <> ""...
Forum: General 12-05-2017, 06:27 AM
Replies: 7
Question Syntax Error
Views: 429
Posted By Ranman256
Re: Syntax Error

too many quotes:
strRowSource = "SELECT [colorant_Change_Date] FROM colorant_lot_Changes WHERE [Press_No]='" & Me!Combo0 & "'"

surround the string in single quotes.
Instead of SQL , you can...
Forum: Modules & VBA 12-04-2017, 08:55 AM
Replies: 16
Views: 282
Posted By Ranman256
Re: Form Property Event

The timer event is correct, and if the form is open it runs.
BUT, timerinteval =1000 is 1 second. (its in milliseconds)

set the inerval = 3,600,000 (1 hour)
then the code will run.
Forum: Forms 12-04-2017, 06:56 AM
Replies: 3
Views: 129
Posted By Ranman256
Re: Alter all controls top variable in code

you are making too much extra work for yourself.
Forum: Forms 12-01-2017, 06:57 AM
Replies: 14
Views: 252
Posted By Ranman256
Re: Pull value from another form

That is all you do, but I dont think it will work in a text box.
it works in vb code.
it works in queries (without the = sign)

make sure your control has the correct name, NumOfProv
(you can...
Forum: Modules & VBA 12-01-2017, 01:41 AM
Replies: 4
Views: 179
Posted By Ranman256
Re: Trouble with WITH... and report

you wouldnt filter in a report. The query does the 'filtering'

and you wouldnt set the filter = "", instead just turn it off...
FilterOn = false
Forum: Queries 12-01-2017, 01:11 AM
Replies: 3
Views: 151
Posted By Ranman256
Re: sum from initial values minus values used in other table

you would use append query to write the reward to the person's income table
tPersonPayments table
personID, Amt, PayDte, Note, reconcile
123, $10, 1/1/17, 'reward', false

you would then have...
Forum: Forms 11-30-2017, 05:27 AM
Replies: 2
Views: 141
Posted By Ranman256
Re: Point of sale system for a restaurant

I would go and purchase an out of the box system.
They already connect terminals to the servers,cooks, and admin.
Doing it from scratch on an Access db wouldnt be efficient. (plus the design/debug...
Forum: Modules & VBA 11-29-2017, 06:46 PM
Replies: 1
Views: 125
Posted By Ranman256
Re: Using VBA to access MS Project Task

google it. Theres a series of steps. I used it and it works.
Build a macro to do it in 1 click.
Forum: Forms 11-29-2017, 06:44 PM
Replies: 4
Views: 157
Posted By Ranman256
Re: Browse for file glitch

you didnt say what you are using to browse.
Forum: Modules & VBA 11-29-2017, 06:12 AM
Replies: 6
Views: 145
Posted By Ranman256
Re: error in insert into table

you should use queries instead of sql. A query will show you the error, but
im guessing [employee_id] is NOT a string, but numeric so remove the quotes:

"INSERT INTO tbl_recipients (forname,...
Forum: Queries 11-28-2017, 08:46 AM
Replies: 1
Views: 107
Posted By Ranman256
Re: Can't Update when Linked

some tables will not allow this due to the relationships.
check yours to see if it will allow.
Forum: Forms 11-28-2017, 05:31 AM
Replies: 1
Views: 128
Posted By Ranman256
Re: file not found

is the login form the database login because its passworded database?
is this an internal form you created for users to 'login'?
Showing results 1 to 25 of 500

Forum Jump

All times are GMT -8. The time now is 11:20 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 - 2017, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World