Search results

How do I make a variable both public and static? At least I think that is what I want to know - let me explain. I have a form that I get to from a button on another form. The following code is on the button click event and works fine, Private Sub Special_Needs_CmdBtn_Click() On Error GoTo...

OK - so now I know the reason (doesn't seem very logical but then a lot of things that MS products do or don't do aren't very logical). Thanks for that. So my next question is - What is the best way to close a form when it is no longer required? There seems to be lots of ways to do it but...

If you click on File -- Database Properties -- General tab you can see the file size. There must be a simple way to reference this value in code, both before and after you import the data But you can always do it manually for three clicks.

When does a form lose focus? I have a point in my routine where I have two forms open at the same time. Form_1 and Form_2 I want Form_1 to close when it loses focus, so I put the code: DoCmd.Close in the On Lost Focus event of Form_1 but it doesn't work. I can move to Form_2 and enter data...

Mile-O-Phile.....Many thanks for the pointer Works a treat. Sprocket

I have a database that I inherited, which I now have to maintain. Works OK in the main but one table is causing me problems. The key field ... Student ID is a 9 character text field. There are several possible entry formats for this S******* = 1 letter and 7 numbers S******X = letter, six...

Am I missing something? I thought autocorrect was a means of propogating changes to the names of objects. Does it correct other things?

OK.... I'm not sure why your system is stripping out trailing spaces because mine doesn't and I have to put a bit of code into the after update event to strip trailing spaces out. The following is a stripped down piece of code that I use to put the date into a memo field ecah time I enter to add...

I don't like wizards... they do things that can't be easily undone. I tried splitting a database in Access 97 using the wizard and it totally trashed my database. Happily I had a backup and I've stuck with the solid model ever since. But A2K may be better so I'll give it another go.

Fizzio -- I have found your "Checklinks" code and will give it a try. I have avoided the FE/BE split up to now as it seems rather daunting..... but I suppose we all have to grow up and fly the nest some time. Many thanks......Sprocket

I have an A2K database on a shared drive - usually with 8 to 10 concurrent users. Recently we have experienced some network difficulties whereby we temporarily loose contact with the server. This is NOT a problem related to Access but to a Netware system upgrade. However, the first you know...

Hi. I'm not sure there is "a way to turn it off" but I think of a way to force blank lines/and/or spaces using a bit of code in the - on focus/lost focus events. Can you give me a little more idea of the use that the blank line/spaces will serve? Do you want this to occur every time you...

Hi folks - thanks for pointing me in the right direction. I have now found a solution - for anyone interested it is as follows: Place the following code in the "On Enter" event of the combo box [Forms]![Special_needs].FilterOn = False [Forms]![Special_needs].Form.Refresh

Sadly no, I'm afraid not - it is too early in the cycle because the code that moves from form 1 to form 2 in effects sets the filter to the record I want it to open on therefore form 2 opens on the last visited record rather than the record that is currently selected on form 1 I think it needs...

Hi, I have a multi-user database sat on a shared drive. It has upto 10 concurrent users. I've got two forms REGISTRATION and SPECIAL_NEEDS both forms use the same underlying query for their data The Registration form always opens in add mode expecting you to enter a new student. It also has...

Help this is doing my head in. I have not set anything up yet as I can't work out how many tables I need and thus what the relationship should be. Here's the problem: I have a number of students with support needs. OK make this tblSTUDENT I have a number of support workers. Let's make this...

OK - This might not be elegant but it will work. Lets assume you have a field in your primary table that numbers each record sequentially from 1 stepping up in integer values of 1 ie. 1,2,3,4,5......100,000 open a new Excel spreadsheet. in cell A1 enter the formula INT(RAND()*100000)+1 Copy...

I need to write to a group of students about 500 who have met certain criteria - I know their name and student number. The student number is the unique identifier I use in my Access 2000 database. However, I foolishly expected central records to provide Term-time addresses for my study group...

Many thanks for your suggestion Wayne - nice idea - and it does work to a limited extent. The problem is that it trips out as soon as the Control key is pressed - well before the ; key is hit. Obviously compoite keystrokes are not catered for. However , I now know that the keycode for...

I have a memo field that I use to keep running notes of interviews with my students. Whenever I see one of my students I want to be able to click into this field and use the hot-key combination CONTROL + ; (semi-colon) to enter the current date and then write up notes on the interview. Simple...