Search results

Hey, vbaInet - just out of interest, not sure what I've done, but this now only updates when moving to the next record on the form...

Wow...that was super simple...classic case of over-complicating the matter... Thanks vbaInet - that worked perfectly! :)

Hi guys. I'm having some problems with this - clearly a bit of a basic one so apologies in advance. I'm currently in the process of creating a form to be used in an upcoming calling campaign, and I'm trying to get 1x combo box and 1x text box to update the Date/Time field that shows when the...

Hi Mr. B - thanks for this, I'll have a butchers online and see what I can come up with.

I'm trying to open a report from a Button on a form, but when the report opens it hides behind the other forms on-screen, meaning you have to go to Window and then select it to bring it forward. Here's the code I'm using in the on-click event of the first form: Private Sub btnPrint_Click() On...

Hi all, I'm adding a label with some text to a form that our call centre will use in an upcoming telesales program, but it appears to be dropping out the last full stop and replacing it with a dupe of the preceeding character. So the last sentence in the label looks like this when I type or...

Thanks, Winshent!

I've got some code together that deletes a table by name: But I need to do it "in bulk" - has anyone got any suggestions on the best way to build a list of table names within the db and then run it into my delete code please?? Thanks, J.

Right - excellent, it makes sense!! Thanks again!! :)

That's brilliant, thanks very much - would you just be able to explain a little bit about how that works please?? Added to your rep, btw! :)

Hi guys, I'm trying to return Mr Stevenson (if we're missing the First Name), Mr James Stevenson (if we have the First Name) or James Stevenson (if we're missing the person's Title) as an alias in an Access query, but can't quite get it right. This is what I currently have: Contact...

Hi Dave - thanks for replying. If no booking exists then the form will open in Add mode: If btnBkg.Caption = "Amend Bkg" Then stLinkCriteria = " [BkgContactID] = " & Me.[Contact ID] DoCmd.OpenForm stDocName, , , stLinkCriteria Else DoCmd.OpenForm stDocName, , , , acFormAdd...

Hello all, I'm not 100% sure on the best way to explain this problem, but we run a number of events throughout the year, and each one has its own MS Access 2003 "bookings" database, where you can add new sites (companies), contacts etc. We have a main form where you search on site name, and...

Hi Smig, thanks for this! :)

Hey guys - me again!! :D We have a number of databases that use MS Access for both front and back ends, and I need to write a script that deletes a linked table from the front end and replace it with the relevant table in a seperate SQL backend. I have no clue on where to start with this, so...

Hi all, We are currently looking at migrating some of our MS Access 2003 databases onto SQL Server in order to speed them up, but we'll still be looking to use Access 2003 as the user frontend. I have been tasked with displaying one "parameter" (my boss's word, not mine!) from the SQL Stored...

Hi guys, We run regular order fulfilment from our Access 2003 dbase, which prints labels (18 per page) to our RICOH printer. The user can choose whether they want the labels to feature a PPI (postage stamp) or not from an option group containing two possibilities - a report "With PPI" and a...

Hi there, I've sorted out this problem: Turns out the print preview for the faxes will "stack", so using the previous/next buttons there will cycle through the available faxes to print!! D'oh! :)

It's a single form with previous/next buttons to cycle through the records. Thanks for the code...just putting that in now!! :)

Hello - thanks again! The email/fax appears when you tick the check box, but also when you un-tick it as well, and for some reason the email/fax appears for the first record only...so even if you're four or five records down the line, when you tick the box a fax/email for the first record you...