Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.66 seconds.
Search: Posts Made By: Rob.Mills
Forum: General 03-13-2007, 05:22 AM
Replies: 0
Views: 636
Posted By Rob.Mills
Anyone looking for employment in Raleigh, NC

A previous employer came to me for help. He says their access developer has resigned and wanted to find out where he could locate a replacement. I thought I'd start here and see if anyone in this...
Forum: General 08-28-2006, 03:33 PM
Replies: 6
Views: 1,172
Posted By Rob.Mills
Hey guys, Thanks for all your posts. ...

Hey guys,

Thanks for all your posts. SleepyJay, to answer your question, I would be a sub-contractor for a couple guys that are running their own business doing all kinds of work. Web-sites,...
Forum: General 08-28-2006, 07:58 AM
Replies: 6
Views: 1,172
Posted By Rob.Mills
Billing rate

Hello all,

I am talking to a potential customer about doing some contract work using access. This would be my first contract using access and I was just curious what some of you are charging as...
Forum: Modules & VBA 01-18-2006, 08:21 AM
Replies: 3
Views: 24,075
Posted By Rob.Mills
I guess I didn't explain completely. What I want...

I guess I didn't explain completely. What I want it to is open the database so the user can use it just as if the user had double-clicked on the file icon.

I think you have to use wscript or...
Forum: Modules & VBA 01-18-2006, 07:57 AM
Replies: 3
Views: 24,075
Posted By Rob.Mills
Open an access db from vbscript

I know this can be done but can someone refresh my memory on how to do this?
Forum: Queries 01-16-2006, 01:33 PM
Replies: 3
Views: 590
Posted By Rob.Mills
Actually, I found out since I created this...

Actually, I found out since I created this thread, that you can but you have to execute the sql through ADO. Why, I don't know, but it did work.
Forum: Queries 01-16-2006, 07:07 AM
Replies: 3
Views: 590
Posted By Rob.Mills
Modifying security using Sql

Is it possible in access to modify user permissions with SQL?
Forum: Modules & VBA 11-08-2005, 07:02 AM
Replies: 1
Views: 665
Posted By Rob.Mills
Hey! Just found it. Run ... Who...

Hey! Just found it.

Run ...

Who would've thought? :cool:
Forum: Modules & VBA 11-08-2005, 06:59 AM
Replies: 1
Views: 665
Posted By Rob.Mills
Call a method by name

Is there a way that I can call a sub or function by passing its name as a string?
Forum: Forms 02-10-2005, 11:39 AM
Replies: 4
Views: 725
Posted By Rob.Mills
Gotta make sure you set each of the properties...

Gotta make sure you set each of the properties for the combobox

You've got the rowsource correct.

Make sure you set the Bound Column to the first column (assuming the first column is the...
Forum: Modules & VBA 02-10-2005, 10:36 AM
Replies: 2
Views: 758
Posted By Rob.Mills
If you create a variable to equal the worksheet...

If you create a variable to equal the worksheet you're using such as xSheet then your line would look something like this:

xSheet.Cells(Row,Column)
Forum: Modules & VBA 02-10-2005, 10:34 AM
Replies: 1
Views: 851
Posted By Rob.Mills
Is there a particular reason why you want to put...

Is there a particular reason why you want to put store a value that can easily be calculated at run-time?

Also, I've found this forum to be the best source of any info on access or VBA.
Forum: Forms 02-10-2005, 10:30 AM
Replies: 4
Views: 2,329
Posted By Rob.Mills
I don't think you can put a command button in a...

I don't think you can put a command button in a datasheet but you can put the code in the double-click event of one of the controls to get the desired result.
Forum: Forms 02-10-2005, 10:28 AM
Replies: 4
Views: 725
Posted By Rob.Mills
For the rowsource of the combobox use a query...

For the rowsource of the combobox use a query that pulls the field OrderNumber and the description field.

Then set the columncount property to 2.

Then set the column widths property to 0";1"...
Forum: Modules & VBA 02-10-2005, 10:26 AM
Replies: 5
Views: 73,157
Posted By Rob.Mills
You can either create a delete query and then...

You can either create a delete query and then call the docmd.openquery in VBA

or you can run the Docmd.RunSql "Type the Sql in quotes"
Forum: Modules & VBA 02-10-2005, 10:24 AM
Replies: 2
Views: 900
Posted By Rob.Mills
Use the mid function So you would say...

Use the mid function

So you would say Mid([Field Name],5)

This would take everything starting with the 5th character.
Forum: Modules & VBA 02-10-2005, 10:23 AM
Replies: 3
Views: 765
Posted By Rob.Mills
Will Docmd.Outputto not suffice?

Will Docmd.Outputto not suffice?
Forum: Macros 01-26-2005, 10:24 AM
Replies: 4
Views: 921
Posted By Rob.Mills
You were correct. Something in the query was...

You were correct. Something in the query was causing the issue. Thanks.
Forum: Macros 01-26-2005, 10:09 AM
Replies: 4
Views: 921
Posted By Rob.Mills
Well all the macro does is an OpenReport command...

Well all the macro does is an OpenReport command and the next line is Quit.
Forum: Macros 01-26-2005, 06:34 AM
Replies: 4
Views: 921
Posted By Rob.Mills
Using autoexec

Hello,

I have recently been upgraded to XP from 2000 and now one of my dbs is giving me trouble.

I had an autoexec macro setup that would print a report and then close the database. But now...
Forum: General 01-25-2005, 08:23 AM
Replies: 6
Views: 1,004
Posted By Rob.Mills
I've got my default format as 2000. Which I'd...

I've got my default format as 2000. Which I'd like to keep for a little while as not everyone in the company is upgraded yet.
Forum: General 01-25-2005, 07:49 AM
Replies: 6
Views: 1,004
Posted By Rob.Mills
Creating MDE's

Hello,

I've been using MDE files for quite sometime and just recently the network guru upgraded me from 2k to XP. Now when I go to create an MDE file the option is disabled. Anyone know why this...
Forum: Queries 01-18-2005, 09:44 AM
Replies: 2
Views: 586
Posted By Rob.Mills
When you switch a query to an append query it...

When you switch a query to an append query it prompts for the table as well as a data source. That's where you can specify the file.
Forum: Modules & VBA 12-20-2004, 08:32 AM
Replies: 1
Views: 874
Posted By Rob.Mills
What I usually do in this situation is create a...

What I usually do in this situation is create a module variable to store the value of the parameter and then a public property to retrieve the value. Then you can set the query for the report to...
Forum: Modules & VBA 12-17-2004, 06:02 AM
Replies: 7
Views: 1,154
Posted By Rob.Mills
The only way I know to write to a text file in...

The only way I know to write to a text file in access is to use the streamwriter.
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 06:29 AM.


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