Search results

I have no problem with the table. I just sent this example mdb so you could visualize what I am trying to do. In this mdb I have only three fields, Symbol, PPM and Color. Originally, the client inputs a Symbol, a PPM value and, I had a List Box for the Color, with the list: "White", "Blue"...

Vba I am not familier with VBA. I did add an Event on the AfterUpdate and this did not work. I am enclosing an example default.mdb.

How can I Default a Text Box value by the input of another two Text Boxes. This Expression on the Text Box Default Value does not work. =IIf([Text0]=0 Or ([Text8]="<" And [Text0]=1),"White",IIf(([Text0]>=1 And [Text0]<=49),"Blue",IIf(([Text0]>=50 And...

Thanks I will give it a try :)

I have a split DB accessed and updated by several Users. How can I limit the update of one table to only one User, administrator if you will. :confused:

Thanks Great idea, the join field is the CustomerName, I am just going to break it down by alphabetical limits, A,B, etc. Thanks :D

Oracle For some reason, even an APPEND query to Oracle takes hours, if it is over 250k records. I do not have access to run in the Oracle server, which is a Windows 2003 server. Therefore, I have a Link to the Oracle table thru an ODBC data source. The SQL is a simple Update: UPDATE [New Addr]...

I am updating a 800k record Oracle table. My Update Query runs for a few hours, then dies with a Exceeded Resource Limit error. Can I built a Macro that will run maybe 10 update queries updating 100k records each. How can I limit each update query to 100k rcords and how do I start the next query...

Great That did it. I am running my Update Query now. Thanks :D

I have a table, to which I added three new columns. I need to populate these three columns. The data is in three columns of a linked EXCEL spreadsheet. The table and spreadsheet are joined with other columns. I created an Update Query, but when I put the name of the corresponding column of the...

Deploying I need to copy the fe to each of the client's pc because the application creates temp tables for the reports. Therefore all client's will have r/w access to the fe. I am not allowing access to the db design by checking off all views in the Startup before deploying. I will keep a copy...

Split I split the mdb because I thought this was the best way to deploy an application on the network for multi-user access. Is there a better way? I am having problems understanding security and may just go with LAN security; create a LAN workgroup with users having r/w access to the folder...

Splitting I use the Database Splitter under Tools/Database Utilities. I am going to house the be(tables) on the network and the fe will be copied to each of the client's workstations with a link to the be.

I found a good place to start security: http://support.microsoft.com/defaul...kb;en-us;289885 However, since I am going to deploy the application on the network with half the clients having r/w and the other half read only, should I split the mdb first than build the security on the fe, or...

Security before split Found a good place to start http://support.microsoft.com/default.aspx?scid=kb;en-us;289885 However, since I am going to deploy the application on the network with half the clients having r/w and the other half read only, should I split the mdb first than build the...

Now Working Moved the MoveSize just before the Openform(Switchboard) and now all working as expected. Thanks all

Autoexec Looked at the Error. Apparently, the Autoexec is being executed, but there is a problem with the MoveSize. I have no problem with it when the Database Window is not hidden and the Autoexec runs, sizing and moving the Switchboard where and how I want it. :mad:

Setting up security I am also trying to set up security and find the documentation difficult to follow and very cumbersome. Why can't anyone come up with a cookbook or simple check off list to follow? 1. Click on Tools/Security 2. Than What? User Level Security Wizard, User and Group Accounts...

Autoexec Well, I am back at the office. Tried this, but the Autoexec did not run after unchecking the Display Database Window. I put Switchboard in the Display Form/Page and it does display the Switchboard, however I Size and Place the Switchboard in my Autoexec. How can I run it, after...

I have an application that goes directly into the Switchboard with an Autoexec. When it was in the development phase, I would launch it and it would display the Switchboard, as I expected; however if I scolled down I could see and open all the database objects to continue with the development. I...