Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 182
Search took 0.04 seconds.
Search: Posts Made By: scottfarcus
Forum: Reports 03-30-2007, 08:51 AM
Replies: 0
Views: 529
Posted By scottfarcus
Duplicate Records

I am attempting to develop a dynamic query capability in one of my databases.

tblStaff: a list of staff names in one table (StaffID key)

tblCars: a unique list of Cars (CarID key)
...
Forum: General 12-11-2006, 04:35 PM
Replies: 4
Views: 4,000
Posted By scottfarcus
Writing an effective MS Access developer resume

After almost 10 years developing MS Access applications for the government, I'm attempting to write an effective resume to begin my job search. I've single-handedly designed, tested and implemented...
Forum: Modules & VBA 12-07-2005, 03:28 PM
Replies: 5
Views: 2,287
Posted By scottfarcus
DoCmd.RunCommand acCmdNewObjectReport ...

DoCmd.RunCommand acCmdNewObjectReport
DoCmd.RunCommand accmdnew
Forum: Modules & VBA 05-27-2005, 05:05 AM
Replies: 0
Views: 741
Posted By scottfarcus
Turn Off "Look In" pull-down when using Common Dialog API

I am using the common dialog API sampled here (http://www.access-programmers.co.uk/forums/showthread.php?t=75790&highlight=common+dialog+api).

Users are able to link a powerpoint file to each...
Forum: General 05-08-2005, 09:23 AM
Replies: 10
Views: 1,646
Posted By scottfarcus
probably the most impatient "poster" on these...

probably the most impatient "poster" on these boards. I'll be surprised if you get help...
Forum: General 03-26-2005, 12:12 PM
Replies: 3
Views: 630
Posted By scottfarcus
Use the attachment (credit to whomever first...

Use the attachment (credit to whomever first posted it here - it wasn't me) to find code that does what you want. I'm sure you're capable of making the form and the buttons.
Forum: Forms 03-15-2005, 10:36 AM
Replies: 0
Views: 491
Posted By scottfarcus
Start at certain record in combo box

My users select from a combo box one or more criteria. The criteria are numbered 1-20.

Typically, the user would need to select 1, 4, 5, 6, 10, 15, 16, 17, 18, 19, 20.

It is somewhat...
Forum: General 03-15-2005, 10:31 AM
Replies: 0
Views: 802
Posted By scottfarcus
Word Doc closes when opened via OLE

I have a database that stores reports (both the path and the actual document) and a form that displays the report list showing the doc. When I dbl-click the OLE box to open the report in Word it...
Forum: Forms 03-10-2005, 06:29 AM
Replies: 7
Views: 869
Posted By scottfarcus
g, fScanDirSelectFileFromCombo displays the...

g,

fScanDirSelectFileFromCombo displays the *files* inside the drive or directory. I would like it to also display the *folders* inside the drive or directory. I don't believe it can be done,...
Forum: Forms 03-09-2005, 04:46 PM
Replies: 7
Views: 869
Posted By scottfarcus
Can it display a list of the folders in the...

Can it display a list of the folders in the directory as well?
Forum: General 02-26-2005, 07:01 AM
Replies: 290
Views: 113,135
Posted By scottfarcus
Audit Trail works beautifully, thank you! ...

Audit Trail works beautifully, thank you! Simple, but very effective.

However, can anyone provide a solution to this issue:

When updating data in a combo box (Autonumber field as the bound...
Forum: General 10-25-2004, 03:20 PM
Replies: 2
Views: 13,755
Posted By scottfarcus
Perfect. Thank you.

Perfect. Thank you.
Forum: General 10-14-2004, 08:30 AM
Replies: 2
Views: 13,755
Posted By scottfarcus
How do linked tables work?

Can someone explain to me, in plain English, how linked tables work? I have been developing split database apps for years, but lack the verbiage to explain to end-users how the linking functions.
...
Forum: Modules & VBA 06-02-2004, 07:35 AM
Replies: 0
Views: 2,386
Posted By scottfarcus
Automating an Outlook Meeting Request

I am using the following code in my database to send out an Outlook Meeting Item.

As it is now, the message is sent to the right people, but appears as a normal message instead of an invitation,...
Forum: Modules & VBA 03-10-2004, 09:33 AM
Replies: 1
Views: 789
Posted By scottfarcus
I've had the same problem. Sorry I can't provide...

I've had the same problem. Sorry I can't provide a solution, but hopefully we'll find an answer here...
Forum: Macros 02-29-2004, 03:36 PM
Replies: 2
Views: 1,351
Posted By scottfarcus
The field in your main table that relates to the...

The field in your main table that relates to the Service table is indexed.
Forum: Modules & VBA 02-27-2004, 06:48 PM
Replies: 3
Views: 1,460
Posted By scottfarcus
I found automating MS Project to be the most...

I found automating MS Project to be the most effective solution. If you'd like to explore this option, email me.
Forum: Modules & VBA 02-27-2004, 10:04 AM
Replies: 2
Views: 924
Posted By scottfarcus
Use DoCmd.SetWarnings(False) to turn off the...

Use DoCmd.SetWarnings(False) to turn off the warning message before you run the Update query.

Use DoCmd.SetWarnings(True) to turn them back on after you run the query.
Forum: Forms 01-27-2004, 05:05 PM
Replies: 1
Views: 757
Posted By scottfarcus
Please see answer in Modules & VBA forum.

Please see answer in Modules & VBA forum.
Forum: Modules & VBA 01-27-2004, 05:03 PM
Replies: 3
Views: 853
Posted By scottfarcus
You need to set a reference to Microsoft DAO for...

You need to set a reference to Microsoft DAO for this method to function properly.

Open any code window.

Go to Tools>>References.

Find Microsoft DAO 3.51 (or 3.6) and check the related...
Forum: General 11-25-2003, 09:08 AM
Replies: 11
Views: 1,342
Posted By scottfarcus
Decent idea, but I don't recall anything in the...

Decent idea, but I don't recall anything in the original post about needing to know when a record was deleted or by whom. Seemed to only be concerned with limiting the view of certain records and...
Forum: General 11-25-2003, 08:31 AM
Replies: 11
Views: 1,342
Posted By scottfarcus
Why not add a field to the table in question...

Why not add a field to the table in question called "Deleted".

Make it a Yes/No field.

Change the record source of the form to ONLY include those that are NOT Deleted.

Make a button that...
Forum: Forms 11-18-2003, 09:00 AM
Replies: 2
Views: 590
Posted By scottfarcus
change the control source of the point_total text...

change the control source of the point_total text box to:

=IIf(IsNull([Combo15]),"",Nz(DSum("Points","tbl_points","ChildID = " & [Combo15] & " AND Active = 0"))+[text19])
Forum: Modules & VBA 10-16-2003, 10:45 AM
Replies: 26
Views: 25,501
Posted By scottfarcus
Moe, Not sure I can help. You may have...

Moe,

Not sure I can help.

You may have to change the field name.

For future reference, use the following as a guideline for creating fields and other objects in your databases...

Access...
Forum: General 10-04-2003, 06:47 AM
Replies: 2
Views: 919
Posted By scottfarcus
Download WinZip...

Download WinZip (http://download.com.com/3000-2250-10161502.html)
Showing results 1 to 25 of 182

 
Forum Jump



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