Recent content by Rob.Mills

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 area is in the market.

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, Win32 apps... mostly .NET but they have some customers that are not ready to upgrade their apps from...

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 your rate. I'm a strong developer but my experience has been in a full-time position so I'm not...

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 something to that effect.

I know this can be done but can someone refresh my memory on how to do 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.

Is it possible in access to modify user permissions with SQL?

Hey! Just found it. Run ... Who would've thought? :cool:

Is there a way that I can call a sub or function by passing its name as a string?

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 OrderNumber). That will make the combobox equal to the OrderNumber. Then set the Columncount to 2 so that...

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)

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.

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.

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" (you can set the widths to whatever you want. Setting the first one to zero hides the number field)

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"