Search results

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.

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

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

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

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 when I open the db it gives me a message that one of the components is missing. The weird thing is...

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 would happen? Thanks

This is a rewording of a post I created a few hours ago. I have some module level variables that seem to be losing their value when I don't want them to. I noticed it happening when I opened another form in dialog mode. What would cause these variables to lose their value? I thought their...

Does anyone know what would cause a module level variable to lose it's value while an application is in use?

I have two subforms that are related. The first one is a datasheet showing all the records and the other is a single form showing more detail. What I'm trying to do is when the user modifies a record in the single form then have those changes propogate to the datasheet. I've tried using the...

Does anyone know of a way in access where you can open a modal form that will pause the code from which it was opened. Kind of like in VB where you can do a ShowDialog and then pickup in the code using the result from the ShowDialog.

I am running a pass-through query on an Oracle server. I'm trying to break down a date field to see only the month. Is there an equivalent for Oracle to using Month([Date Field]) in Access?

Is there a way to prevent a user from opening multiple instances of a database?

What is it with crosstab queries?? I have one based off another query. In the first one there is a criteria that references a combobox on a form. Running that query works fine on that criteria. But when I run the crosstab off of it it says it doesn't recognize that parameter as a valid field...

Hey everyone, I'm trying to use pass-through queries for the first time. Trying to access an Oracle server through Access. I've had tables linked from the server for a while so I know I can connect to it. For my first query I tried something simple just to try it. I setup the connection...

Hi all, I have a folder on our network that contains several backends. They've been working fine for quite sometime. Just in the last couple of days people have been getting errors when they try to update a record that says record is currently locked could not update. Then the FE just...

Is it possible from one database to open another database in code and do a transfertext command on a table in the database opened in code?

Is there a docmd or something else where I can export a query to a csv file?

Does anyone know how to create a procedure that will take a string and test to see if it fits a certain format?

Is there an easy way to open a file from vba code?