Search results for query: *

I wonder if anyone can help please I have a form based on a table which has one field and which contains 3 days of the week, mon, wed, and thurs. I refer to these dates from a list in a main form. I have to manually enter the dates in advance which is a bit time consuming and I wondered if there...

G'day all would anybody have an example which shows how to test a form for validation in the before update section. I am trying (without much success) to check to see if all the controls / fileds have been completed, before closing the form. I would like to do this with a VB yesno if I could...

Hello all I am trying to check my various controls 0n a form with something like the following If Isnull me.XXX then control. set focus. cancel=true what I think I need is to get my code to check all controls in one piece of code rather than duplicate my code for every control,and then say, a...

Greetings all would you help with the following please I want to prduce a report on a vb yes no box, I have the first bit, but my report prints on both the yes answer and the no too ! could you fill me in please or is there an easier way than my attempt ? Private Sub Command81_Click() On Error...

good evening all would anyone please be kind enough to show me how to use the Len expression in a query pane I Have so far this much expr:len([name]) but I would like to show only the first 4 characters in the query result, so far I only get the number of names thanks nicky

Could you help with the following please I have a combo box that I wish to add a name if not already on the combo list / Table. Is there a way to check and then ask I want to add the new record to the table and therefore combo afterwards using VB many thanks Nick

hi everyone could you help me understand public functions or global things with the following example please. I have the folowing piece of code which helps me to "check digit" an eight figure number.It is on a bound text box in a form and only refers to that text box.IE using "Me" What I would...

Firstly happy new year all. I wonder if one of you good people could show me the way to make the following available to all forms rather than just one control on one form.I think they call it a global I have the following check digit code for an 8 figure number, using the mod method.This...

I wonder if any nice kind person could give me the answer to the following. I have a list box with 3 columns, date / time / Count I have the number 10 in the count column (which come from a table) I also have a text box (unbound) which I enter a Y or a N. I would like to reduce the Count by one...

would anyone happen to know of a good "student enrolment" type D/base. pref one with course structure wheere you can add course details etc. The one sample in Access 97 is not really up to scratch thanks Nick

Would anyone have any idea why my winXP restarts after I have selected shut down ? All shuts down Ok but then like the undead it starts up again, will I have to drive a stake through it's heart ? thanks Nick

Greeting all I wonder if anyone can help When I shut down XP (home Edition) it starts up again ! almost like auto re start can you help here ? Rgds Nick

g'morning all I wonder if anyone could recommend any publication which clearly shows how to make functions, where to put them, and when to use them, how to call them etc. Even a simple example type book would do. Or perhaps there are some web pages somewhere. thanks Nick

Good afternoon all I have put the following code inmy lost focus event and it thows out an error saying "that it cannot execute this type of etc" Private Sub close_main_LostFocus() If IsNull(Me!List90) Or IsNull(Me!StaffMember) Then Dim IntResponse As Integer IntResponse =...

Good evening all I wonder if you could help with the following I hjave the following code which is attached to a "close" button on a form. When I close the form without any fields being entered I get a message cant undo etc.So I have added the "Now" to a field so that it will...

Good morning all I wonder if anyone has the answer to the following please. I have for example 2 columns , column "A" and column "D" which I want to print on one page.When I highlight both columns by the cntrl key and to set the print area it still prints the "in...

Greetings all I am using the following code to send the results of a query to Excel DoCmd.OutputTo acOutputQuery, "Import op by week", acFormatXLS, "C:\Test.xls", True It sends it OK but makes a new spreadseet every time. Can I alter the code to send the results of the...

Greetings all would you kindly take a look at the following code and maybe tell me what is wrong. I am trying to add a name to the underlying table if what I type is not on the Combo list. Private Sub cbxAEName_NotInList(NewData As String, Response As Integer) Dim db As DAO.Database Dim rs As...

Good afternoon all I wonder if anyone has any info on the activex contrl called Axis Control. It looks like a meter of sorts and one which if so, I think I could use to show say the amount of items in a list or say, when the items are getting low on the list. Does anyone have any info on its...

Hi everyone does anyone have a code which would enable me to send the results of a query to excel, say via a button on a form (on click) would appreciate any help on this as not mucho hair left. Thanks Nick