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...

Yes, I know thank you. I had already fixed it before I saw your reply, but thanks

Was about to reply that I used xlApp.Visible = True in the command; That seems to have done the trick - thanks so much Regards Andy

Thank you both so much! The first example shown works fine aprat from the fact Excel doesnt show (as explained in KB it only shows when Excel is open prior to the command being run. There is no way to see if things have worked apart from opening the xls to check - the whole point was this would...

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 trevor, thanks for your answers. Still cant get it working correctly, I'll keep trying though!

Like this? Its still listing all the records that don't have an email address.

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...

thanks, perfect now.

Update. The macro option does not display the window i need to unhide - only forms I have created. Any suggestions?

Thanks Trevor. I dont think I've explained myself very well!:confused: The Database Window that I need to unhide is the one that is on the left of access 2003; it contains all the objects, tables, forms, queries, modules and macros etc. By default its visible and shows all the tables & forms...

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...

thats perfect for what I need. Only addition thing I would like is to mask the password ie show "********" instead of "password" Any suggestions?

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...

Fixed it myself, by removing the line .InitialFileName = "C:\Users\" & CurrentUser & "\Desktop" Thats seems to have done the trick, thanks anyway.

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."...