Search results

Check out the StartupShowDBWindow Property in the help system for VB in Access

yup no problem go into the combo's Row Source. It presents you with a window to build the query for the combo. Just put the criteria in the AFE field that you need. If that is not a good enough explaination send me an email with the database attached and I will see what I can do for you...

Hmmmm We had best talk. The answer to the question is that you will need to be able to get the value for both of the dates (times) on the report and then it is a simple equation in another text box after that. This particular topic does interest me, not only do I have diabeties but I also...

You need to place the code in the tab controls OnChange event. This is different the events on each independant tab. Try pasting this code in, making sure to change the name of the Tab Conrtol to what yours is called Private Sub TabCtl0_Change() If TabCtl0.Value = 1 Then MsgBox "Test" End Sub...

Try Opening the sub form by itself and see if it is working. You may get a couple of error messages dealing with linking to the main form. Just OK through those. If you get a message about an something on the subform not having an object then that will be the object that is having a problem...

Well SGT It looks like you have a number of interesting things going on there. However you have not told us what the problem is. Kinda hard to help if we don't know what you need. Unless of course you are looking for somebody to make it for you. If you just want somebody to talk to about it...

Go to: http://www3.sympatico.ca/qaissuper There are a number of free samples there along with one specifically for search options.

Dcount("[Field Name]","table/query","[Field Name] = 'Glasgow'") Of course it is more common practise to have the Glasgow in some other object on the form such as a text box or combo box in which case it would be: Dcount("[Field Name]","table/query","[Field Name] = [Textbox/Combo]")

Well generally if you right click on the control source and go to build it will open the expression builder and you would do it from there. There is help available for all of the built in functions. A DCount is structured: DCount("[Field Name]","query/table name","Condition") You many not...

You are looking at doing a DCount on the query. It can be a text box's data source. That will give you the number of records returned.

Yes it is possible First make sure your table has a field that will accept the value. Format it to "mm yyyy" Then create an input mask that will do the same. Then make the text box based upon that field. The formating and input mask should carry through to the form. If you already have the...

Actually it is probably better to have them log in when they get into the program and only allow them access from there. I have attached a sample of one I use a lot. Any problems let me know. technoweenie@sympatico.ca

Well Try starting by making a new table that will hold these values plus a date/time field. Then build a query that will find the last 5 entered based on the date/time field. Make the Listbox based on this query. When you leave the search form or however you are working that part have the...

Try this browse module to see if it will give you what you want.

the IIF statement is used as follows IIF(Condition,True,False) it is in the help system within access.

Actually if you have this in 9 different locations then you should have a backend on the server that everybody is accessing and a front on at each of the 9 locations. If this is so then you should be able to open access and modify your copy (presumably the master copy) then redistribute your...

You have to have an ID number of some sort in the "Residents" table to tie everything together with. There is only one problem I foresee by doing so and that is if the Resident returns but that is another issue all together. So if as you say they add the resident and then instead of adding all...

what you need to do is make the criteria for the query a little bit more complicated by using the IIF statement. Basically you want something like this. IIF(CheckBoxOnThe Form = -1, "Like '*'",ListBoxValue) I think that should work for you though you may have to play with the Like statement a...

I have often found that importing from DBase into Access can be somewhat troublesome. The problem seems to be that on occasion numbers are brought in as text. Of course this can cause problems latter on when trying to math on those fields or records. For my own peace of mind I alway export...

I suppose You should have actually done a DCount but if it work it works