Search results

I'm trying to create a multipurpose password field to enable some privalaged users to edit some fields in my db. I'm trying to pass the FormName and Control Name via open args. Then if the user inputs the correct password it will unlock that field for editing. Here is the openargs...

yes it can be done but you need to account for different users having different screen resolutions. Check out Peters Softwarehttp://www.peterssoftware.com/winmanip.htm he has a good windows manipulation example db that will maximize a popup to fit the desktop.

Sorry I did not properly read through all your code. I'm pretty sure this will work. Call your Function setImagePath there instead like so. Call setImagePath

I will not be able to help on the tab focus issue. I'm sure there is a way.

You need to set the picture property put this where you had the Forms![frmProperties].Form.Requery on your add button. Me.ImageFrame.Picture = strImagePath

I don't see anything here that would be causing that problem. What code is on the click event of your add image?

Let's work on one problem at a time. Are your forms synched?

I suspect your is your problem. Try commenting it out and see what happens.

So you have records that are in costing that are not in pricing. First you will have to append the records that are in costing that are not in pricing to pricing. To update using user imput you will need to create a form for your margin input. In the Design view of your query you need to...

what is the code behind your insert command?

check this thread out sound like you are doing the same thing. http://www.access-programmers.co.uk/forums/showthread.php?t=46329&highlight=Picture&page=2 Check out the movie sample by rahugty.

What code are you sing to open the report? DoCmd.OpenReport "your report", acViewPreview

This is fairly simple I just did the same thing last week. Here is the code I am using. gfsql in my code is declared globally. You will need to use the record source of your filtered data. After you run the report you will have to reset everything again. Dim dbs As DAO.Database Dim rst As...

I recently had a simular issue. I had to decompile compact compile and compact again and all went well afterwards.

Sorry Mythblstr I just realized you are running Access 2007. I am not familar with this version of Access and split forms. I would assume that you should be able to do the same thing on both controls of the form.

Sounds like you are using a check box as the control type. Use a combo box and set its row source type to Value list For Row Source type in 0;Not Completed;-1;Completed leave bound Column to 1 Set the Column Count to 2 Set column widths to 0;1 This shoukd give you a combo box that...

Sound like you need the docs from Len. You can restrict the admin account in the mdw. Its one of the biggest holes in access security. It is kinda of tricky Back up your db first. I can't recall the exact way to do it but I do know that You have to build the the db while joined to your mdw.

I see another possible issue here. If you have multiple users on the same network db your best option is to go Front End and Back End databases.

Unfortunately our SQL does not require a secure login. So I didn't take that into account.

True about all they can do is get at your data. Which I feel is more of a threat than the code.