Search results

Mousemat, Have you considered using an update query. You would be able to use the current CustomerID as the qualifying paramater and update the CustomerTable. Just a thought. Brad.

Canadaboy, Try opening the database using the shift key bypass (ie: hold the shift key down while opening the database) This will bypass any startup options. I have heard of similar circumstances where the switchboard fails conversion. If this works, recreate your switchboard in the new 2000...

Malcy, I have used the following in the past, and found it quite handy. Will not necessarily provide you a solution (or a shorter one either) but may be of assistance. http://www.aadconsulting.com/ezydoc.html Cheers Brad. Attached: Example of table output.

Message off: DoCmd.SetWarnings False Messages on: DoCmd.SetWarnings True

If you want your users to always be able to enter the percent directly (eg 14 for 14%) then you could add the following: Private Sub TextPercent_AfterUpdate() Me.TextPercent = Me.TextPercent / 100 End Sub Just a thought. Brad.

This is an expected outcome. 14 is 14 x 1 = 14 x 100% = 1400% You can enter 14% as 0.14 Yeah, what he said :)

Oops, Just remembered that you didn't post this publically last time. If you do not want it to remain posted, please let me know, and I will remove it. Cheers Brad.

Rough and dirty ;) You will get the idea I think. I added the iif to avoid the #error when cmbDrums is Null. Your logic is correct re: =[control1] - [control2] I would suggest that you have possibly mucked up the txtBox names, or your cmbDrums being Null is causing the prob. HTH Brad.

baker, Is this calculating on the same boxes that I added to your form previously, or is it another form all together?

Followup: BakerBoy emailed me the db directly. Result: The form was using a single line listbox (appearing as a text box) for comparison of Length v capacity. However as nothing was selected in the listbox, it is not possible to compare values (Well it is but they are both NULL). Changed...

Pat, A quick note to keep you sane. AND: To provide info for those following the thread. I hate it when a thread is completed by PM or personal email - Kind of leaves you hanging. After looking at the db sent by BakerBoy, the requery was actually functioning. However, a previous event...

I have pm'd you my address.

Geez BakerBoy, you are making me look bad. ;) The box should be blank unless the total length IS greater than capacity. ** Just noticed that your Length / Capacity are list boxes. You will need to allow for the column number if the values are not in the first column (hidden bound columns...

Pat's previous post listed me.Drum_Number.requery (Must be late in PatLand) You should be able to requery the Drum_Same Listbox. What you are trying to achieve is a useful approach to many problems. I am sure that is only a name conflict or the like that is stopping you from succeeding...

Format your text box as required (Red etc) Then enter the following as the control source: =IIf([Total_Length]>[Capacity],"Warning blah blah","") Where Total_Lenght and Capacity are the names of the txtboxes containing the relevant info. HTH Brad.

in the after update of Cable_Code_Box: me.Drum_Same.requery

Ice, If the computers at school have access already installed, then you do not need to (and can't do it anyway) convert the file to .exe. The .mdb or .mde will simply be able to be copied to the machine in question. If you have split your front and back ends, then you may need to use the...

I'd like a dollar for every time you have said that Pat. ;)

Mike, Not that I would encourage anyone to reduce the size of their package, but.. If you have used the Packaging Wizard, it is likely that you have included the setup files for IE5.1 This makes up ~ 65mb of the package. If your application does not reqiuire IE5.1 (most users would have 5.1...

Hi Andy, Do you mean that you want only 1 database with three frontends (identical) accessing the backend (data) via the web? If so, could you "host" the database at 1 of the three sites (the main site of use preferably) and then access the site using terminal services? Just a thought. Brad