Search results

Hi Everyone I wonder if you could help me I have designed a Memo type program to remind me of all of the things in my life I need to keep track of for example:- Names, Addresses, Birthdays, Serial numbers, Expiry dates e.t.c. It only has 2 fields and a typical record might look like :- 1...

Hi Everyone I wonder if anyone can help me please. I'm trying to change the opening Access Database Splash screen without much success. I am still running Access 2003 and from what I can see with a Google search it should be as simple as naming a .BMP image with the same name as the Database...

Hi Everyone I'm trying to give away a database that i created in Access 2003 as a free standing standalone program. I found the following information on the net: The runtime components themselves are included with any installation of Access 2003. But in order to distribute a runtime solution...

Hi Everyone I have an access 2003 form with a web browser control and a TextBox to display the URL. As I navigate through the web I would like the current URL of the page I'm viewing to always be present in the TextBox bearing in mind I only have the following event properties available in the...

Hi Everyone I know how to put things on to the clipboard, DoCmd.RunCommand acCmdCopy I just want to view the current contents of the clipboard in access 2003 using vba. I Found this code whilst searching for a solution:- Dim DataObj As New MSForms.DataObject DataObj.GetFromClipboard MyString...

Hi can anyone help me please? I have a database where I would like to change a fieldname to something different. I know I can use edit replace in the code and that works ok, but is there a way to change the fieldname in the code, the Table, the queries, and sql all in 1 foul swoop or do I have...

Hi Everyone I want to open the 'Save Backup As' Dialogue Box from the file menu, using a Command Button on a Form in Access 2003. I know you can do this manually but I would love to do it programically. Iv'e looked everywhere fo this but it still eludes me. Any Ideas Please? Many Thank's...

Hi I have an Access Database where I have a textbox on a form where the user types in a postcode. I have a webpage written in HTML that has a textbox where the user types in a postcode which retrieves a Map for the postcode using the Google Map API. What I need to know is, can I get the...

Hi Everyone I wonder if anyone can help me with a problem that has only just started happening. I've been using Excel 2003 professional edition for years now with no issues when it comes to making line graphs. When I now make a line graph, it's perfect when you make it and then if you click on...

Hi everyone I have a database where you click on a music track listed in a listbox and it plays it from its location on my C: drive. When double clicked the file opens and plays in windows media player where it stops at the end with media player still open. Is there a way in access vba to...

Hi Everyone When creating a Command button you can click the picture builder to the right of the picture property and select a picture from the dropdown list of bmp pics that access already has built in. What I would like to do is to change the image on the button if a text box on another form...

Hi Everyone I have a PoPup form with a textbox that displays text from a database search. What I want, is for the user to be able to double-click on a word that they don't understand, the word will then be selected and I need to Copy just that one word into a Public Variable so that i can do...

Hi Everyone I have been asked by my friends daughter who is doing her GCSE IT Course at school, how to embed an access database query into a word document and have the word doc update if the data in the query has changed in the database. I have tried paste special and I can copy the query...

Hi Everyone I wonder if anyone can help please. I have a form with 40 textboxes. They are divided into 4 groups of 10. I need my user to fill in at least one box in each group before closing the form. Is there a way to test each group to see if this has been done and to pop a message box up...

Hi Everyone I wonder if anyone can help with this I have a spreadsheet where in just column A on the first row there is an address. On row 2 there is a phone number. This situation goes down the column for a thousand addresses and phone numbers. What I would like to do is to join each phone...

Hi Everyone Is it possible to recover a form that i have accidentally deleted Thanks for any help Tony

Hi Folks Is there a way to put a cross instead of a tick in an access logic field. We have just paid a lot of money at work for a scanner that only seems to recognize crosses. Thanks for any help Kindest regards Tony

Hi Everyone I have a program that has an end date field called MyEndDate. It is formatted as a short date dd/mm/yyyy Does anyone know a way that i can return this date after being randomly increased or decreased by 6 days either way, into another variable called MyEndDateRandom. Ive tried...

Hi Everyone I have a database that holds all or our students details. It is on our network and is shared by several tutors. It has come to my notice that some tutors who are new to the database are accidentally overwriting other tutors records. Is there a way to check to if any of the...

Hi Everyone Ive created a database using the file system object that creates folders, moves files from one folder to another, etc. This works perfectly on my home pc, but when i try to install it on the server at work I get the following error message:- Runtime Error 429 Active X component...