Search results

Hello I have developed a database and to make it look a little more like a standalone application i have been using API functions to minimise access and by setting the form Pop-Up property to true the forms are still displayed - which gives the forms the appearance that they do not belong to...

Hello Is it possible to limit the amount of characters that are enterd in to a text box. ie set the maximum length to 4? Thanks Chris

I ma having trouble with the DB execute statement. i am trying to delete data from a table that is over thirty days old. Curerntly i am using the code: Dim DeleteDate As Date DeleteDate = Format(Date - 30, "DD/MM/YYYY") CurrentDb.Execute "DELETE * FROM tblCustomerMeeting WHERE MeetingDate<" &...

HEllo Is it possible to add the results of a collection to a list box? Cheers Chris

Hi I have a query on queries. I have a combobox in which the row source is decided by a query that depends upon the result of another combo selection. My problem is that this combo is very slow to populate. Although the tables where the info is being taken from are not that great in size. Is...

Hello Is there a way to determine if a enitre record in a table is unique rather that the individual field of a table? I need to prevent records from being entered if certain records are the same as previose records. IE i need to allow an entry where field1 and field2 are unique but in their...

Hello This is probably a daft question but... I have hidden a table and i have tried everything i can think of to get it back. Does anyone know how to unhide a hidden table? Thanks Chris

Hello I have written a function that allows a "/" to be entered automatically in to a text box at the required point. The format of teh text box is set to "Short Date" If I type the date in by hand eg "12/12/2003" then i get no problems however if i set the function so that thee "/" is entered...

Hello Is it possible to write a query that will search for data that is not a date? I am trying to change a fields data type to 'Date' however there a four fields that are not in the correct format (#dd/mm/yyyy#). I am tiold this when i try to change the tyope and save the table. I was...

Hi this is just a general question about updating tables from code. I have a class which updates a table. The class gets its values from a function which gathers the values from a form. If I leave one of the fields in the form blank i get an error message in the function to warn me of an...

Hi is there a way of determining whether or not a textboxes value has been changed. I am aware of the dirty property but this only determines weather or not a form has been changd - i needed to know weather a specifi text box has been changed Any advice is greatly recieved Chris

Hi I created some ASCII code that only allows a backslash (\) and numeric chartacters to be entered in to a text box. This works fin in the keypress event. However if i create the code in a module as a public function and try to call it from the key press function then the code fails (all...

Hello again.. I need to select three fields from a table however i need to select only the fields where two of the fields are DISTINCT. The final collum is a collum of unique values. I have written a query to selct the fields I require. The problem i am having is when I make the query and Set...

Hello Is it possible to write a query that will compare two tables. This is hard to explain - i dont know the name of this kind of query so i cant do a search. I would be gratefull if someone could point me in the right direction.. Example. Table1 Field1 Field2 Field3 Table2 Field1...

Hello Is it possible to alter a reports property settings at run time using VBA. I cant seem to find the code i need to change the form. Cheers Chris

CurrentYear = Right(Date, 2) It might just be but does the above string not do what its supposed to? If you display the result of the string in a message box it displays 02/01/1900. If i just put in Date then i get the correct result. Does anybody have any idea whay this is happeneing? I have...

Hi I have a table which stores infomation regarding videos and their rating ie: 18, 15, 12. I also have a table of users which stores the date of Birth of the member. From a form if the member is selected and the video is selected (from a combo box) would it be possible to produce an error...

Hi Is it possible to have a macro run only the first time a database is opend per day or assuming the Db is open to have it run at a specified time? Any advice on this is gratefully recieved Cheers Chris

Hi Is it possible to turn off the error messages given by Access using Visual Basic? Chris

Hi Yesterday i posted a question about populating a textbox or label with a primary key depending upon the results of combo selections. This post has seemed to be deleted. I was wondering (in my original post) if it was possible to have a priamry key displayed on a form depending upon the...