Search results

Yes you can by placing some code in your form's BeforeUpdate event. For example If IsNull(myControlName) Then MsgBox "Please enter something!", vbCritical, "Required Entry" myControlName.Setfocus Cancel = True End If This will test for a null, however if you have set at table level 'Allow...

I'll second that ;)

Hi there, There are few things you can do: 1. If you haven't already done so, split the database so that you have a back end (BE) which contains your tables and a front end (FE) containing your queries, forms, reports etc. Place the BE on a server in a shared folder. Ensure all your users have...

As a suggestion could you not create 2 phone fields - one to hold the country code if outside the US and the other to hold the area code and number? The other thing that springs to mind is that how would you tell the difference between US numbers and Canadian numbers since I believe the area...

Hi I'm sure that you cannot format the text in a MsgBox prompt. Usually what I do if I don't want to have the standard msgbox, I create a popup form and give it the look and feel of a msgbox with the added advantage that you format the text to whatever you want.

You can do a couple things to start with: 1. In the startup options (under Tools Menu) untick 'Display Database Window'. To bypass startup options, hold down the Shift key when opening the db 2. You can hide the tables in the database window by right clicking on the table name, select...

Hi Kila I think you might getting confused with variables. When you set a field in a table to a number data type, you are effectively setting it is an integer i.e. store a numeric. Whereas Variables that are delcared in code using the Dim statement are effectively containers in which you wish...

Hi Kila OK to answer your questions: 1 The Set ctl = CommandBars(Menu).Controls("&Suppliers") line basically assigns the name of my menu bar control to the 'ctl' variable. The ctl variable is declared further up on the line Dim ctl as Variant. The lines beneath then test the value contained...

Yes I must update my code :rolleyes: :D

Hi there, I don't actually use macros, I tend to use code. Here's an example of code that I use in my delete button: Private Sub cmdDelete_Click() ' Ask the user to confirm they want to delete the record DoCmd.SetWarnings False JobNo = DLookup("JobNumber", "tblJobList", "[JobNoID] =...

On your form, why not set the 'Visible' property of the control that is bound to your AutoNumber ID field to No Ahhh....Mile-O beat me to it :D

Universal Naming Convention. You basically type the full pathname to the back end tables when the Linked Table Manager prompts for the location. e.g. \\ServerName\FolderName\FileName.mdb

Hi there, I always copy the front end to each machine and use the Linked Table Manager to connect to the back end. However I don't connect to the back end using a mapped network drive, I use UNC which means all I have to do is copy the front end over to a workstation and away they go. I also...

Well I'm running Access XP with a default file format of 2K on Win 2000 I ran your database both in 97 file format and then converted to A2K and it worked fine on both occasions. Rob

OK assuming that your database is on your hard drive as you say, could there be some code that is trying to open a file on the network? I'm referring to the path name being hard coded and that the target file has been moved or is no longer available on the specified network drive / folder.

Hi Ok I understand what you want. It's that Friday feeling :rolleyes: I'm playing around with your db at the mo so I'll see what I can come up with. I'm due to leave work shortly so it may not be until Monday before I can send something back to you. On further reflection you are trying to...

That's a new one to me. As far as I understand it, it shouldn't matter what version of Windows OS is running but I could be wrong:p One thing I did have a problem with was sharing a front end .mdb on Terminal Server. This caused the back end tables to corrupt constantly so in the end we did...

Presumably you mean the background colour Unfortunately you can't. But you could use a label and set the 'Special Effect' property to raised so that it looks like a command button. Then use the On-Click event for code. HTH Rob

Hi RobJ OK I've downloaded your db but I need to make sure I understand what you want. One thing that springs to mind firstly is why do you need to keep budgeted sales and actual sales in seperate tables? Should the two tables be related to one another?

Hi there Wow :eek: What you're talking about takes a lot of design work and expert programming. If you're looking to study VBA in Access 97 or database programming with Visual Basic then you might want to consider investing in some books. The amazon website has some excellent books relating to...