Search results

Hi guys / gals. I have searched everywhere, but cant find a solution to this - I think everything I have found has been far to complicated. I have a Form with a memo field on. How can I have a "live" text search box on that same form to display results in the memo field as they are found. All...

Hi guys Its been a few years since I used Access, and despite searches I cant find what I'm looking for. I have a VERY simple form, with only one record on it - "address". I have some print buttons which will print that address to different size labels, and some navigation items, but only one...

hi peeps I'm after a bit of advice on where to start with a project. I need to be able to browse to and open a folder from a form, and import images from within that folder to (i guess?) another form? I then need to print each image on 3 different reports, but in order as below... Image 1 -...

Hi everyone. I want to run a search of my table "customers", and search in the "town" field for a certain town, but only display results of customers with an email address. Id normally do a search by the following Like "*" & [Search customers by town] & "*" So, is there a way to exclude...

Hi all I have tried searching, but cant find a solution that works, so I'm pleading for a bit of help! I have a DB (access 2003) with approx 30,000 records on. All works fine, and this DB is split into CSD.mdb and CSD_be.mdb I have the front and back ends residing in a folder on my PC I have...

Hi everyone. I have a "admin" area in my access 2003 DB. On this form I have a button, with the following code... DoCmd.SelectObject acTable, , True DoCmd.SelectObject acForm, Me.Name ... which when clicked, opens the main DB window. The problem is, I cant edit - that is to say, I cant right...

Hi guys / girls! I'm looking to password protect a single form, lets call it frmAdmin. I have looked into various different login methods, with access restrictions for each user, but to be honest this is overkill. I am the only admin, and I have a form I'd like to be able to access without...

Hi guys. I have a split DB, with the Backend on a NAS drive, and a copy of the front end on 4 PC's in the office. Everythings works great, or at least did work fine until today, when an unexpcted error has occured. I use some code to import data, via DoCMDTransfer. Code shown below...

Hi everyone. Is there any vba code for a button to open, and then print an existing PDF on my local machine. For example, c:\test.pdf I've googled loads, but cant seem to get anything working. Win XP, access 2003. Thanks in advance. :)

Hi all I have the following bit of code Private Sub Command6_Click() Dim lngRecordCount As Long lngRecordCount = DCount("*", "Customers") lngRecordCount1 = DCount("*", "Stores") MsgBox "There are " & lngRecordCount & " customers and " & lngRecordCount1 & " stores in the Starlight Database."...

Hi all, and apologies in advance if this is a very bone question, but I have searched and cant find a solution. I have a very simple form, in which the user adds supplier details (company, name, rep, website etc) In the website entry box, is there a way to turn whatever address is entered into...

Hi everyone, hope someone may be able to help with some advice. Im trying to find out the best way to update a xls document from Access2003, via a click button. Basically, I need to copy a customers address, and then paste it into a xls. I dont need the xls to save, just to open and "receive"...

Hi guys I have a form, with the following code on Private Sub searchName_AfterUpdate() Dim LSQL As String Dim LSearchString As String If Len(searchName) = 0 Or IsNull(searchName) = True Then MsgBox "You must enter a search string!" Else...

Hi everyone. I'm looking for a better way to auto import data to a table, via a click button on a form. I am currently using the below method... Private Sub import_Click() MsgBox "You are about to import the photographers work into this database. Please ensure that the staff database is...

Hi guys, I've tried searching but to no avial. I'm looking for some simple code for copying text to the clipboard so I can later paste it to another app. My field i need the text from is "me.stores.address" any help or ideas would be really appreciated. Thanks Andy

Hi I have got into a pickle, by hiding the main database window on startup, and also disabling menus. Now, when i open my db, i only get my designated startup form, and nothing else. I cant unhide my main window because menus are disapled, likewise I cant access my startup options to show main...

I have a form built from a search query, using Like "*" & [Search by Name] & "*" with the results being listed in as a form (in datasheet view) example, a search for Smith, would yield a results list similar to; AM12456, steve smith, 1 high st, london TD23646, helen smithson, 33 the street...

I'll have a stab at explaining this, and offer my thanks beforehand, for the time you're taking to read my problem. Ok, I have a table called "contacts", which is linked to another table called "calls" the idea being that every time a customer calls I can enter a brief call history. I have...

I import fresh data weekly from a xls into access 2003, curretly by going "File, get external data, import", and then selecting xls, and browsing to my file. Is there a way to build an event that will automate this for me, once I click a button (much the same as i can send an email, or dial a...

Hi all. I'm new to access, so apologies if this is a daft question. I have tried searching forums and Google, but cant seem to get an answer. Using access 2003. I have a fairly basic database; name, address, email address - that sort of thing. I have masted mail merge, queries, address...