Search results

HI guys, Is there anything in this code that will stop me from upgrading to Office 2013 (so outlook and access 2013) Private Sub MailPackageWithPass_Click() On Error GoTo Err_MailPackageWithPass_Click Dim Signature As String Signature = "Kind regards," & Chr(13) & Chr(10) &...

Hi Guys, I can't seem to get this to work.... If Reports![PackageReportNew]![PackageDayReportNew].Report!IsNull([Arrive2]) Then Is the syntax correct or does the final! need to be followed by the field name? Arrive2 is a Date / Time field. Thanks!

I have the following bit of VBA which works like a charm : With CallNotes.Form.RecordsetClone .AddNew !CustomerRef = Me!CustomerRef !Who = Forms.markswitchboard!Text52 !Date = Now() !Notes = "Final Deposit Due on" & " " &...

The screenshot attached is taken from a report. This doesn't happen on a form. Any ideas what is causing this and how to solve it?

I have a subform and I want to filter it by location. In the header of the subform I have a dropdown that contains all the possible locations. I then have a button with the following code : Private Sub FilterLocBut_Click() Dim Filtertown As String Filtertown = "Location =" &...

I have a subform that is invisible until I click a button which has the following code : Forms!FrmPassLocation!FrmVenue.Visible = True However, I ALSO want this subform to appear containing just the records that have matching references. I know how to do this if I am just opening a form, but...

MANY years ago my first ever job was trainee Access DB developer. Back then I was taught to use lookup fields in tables. Today I know this is baaaad. Is there an easy way to remove look up fileds from tables, fix the forms and update the data? Is there a bset practice for putting this right...

This is a bit complicated so please stick with me! I have a form that I enter Supplier information into, in this case suppliers could be a hotel, or an activity site for example. It's just a table with supplier information. Because certain suppliers can provide services to multiple towns I...

I'm currently doing a large update to a split frontend / backend database. I've made a local copy to work on. I know changes to front end are easy, I can just over write the file on the client machines. However, what is the best method to update the existing tables. They have new data since...

Will converting an Access 2003 to 2007 database break anything? I know that's a bit general but are there any major pitfalls to be aware of?

If I make a change one of my forms in order to save the record I have to double click the record bar on the left and then press escape before it will save. Has anyone come across similar behaviour and know the cause?

Ok this is driving me bonkers. How do I combine these 2 onlick filters : Private Sub ApplyTypeFilterBut_Click() Dim FilterType As String FilterType = "SupplierType =" & Me.TypeCombo.Column(0) Me.Filter = FilterType Me.FilterOn = True End Sub Private Sub LocationFilterBut_Click() Dim...

Hi there, I've been looking at this for hours and not getting anywhere fast. I have a form that I want to filter based on a combo box. The combo box filter contains only three options. Daytime Evening Daytime & Evening The only difference between this filter and others I have used is that...

I have 2 databases. DB1 holds addresses of suppliers and has a memo field with descriptions of their premises (hotels). DB2 has a form I use to put together info sheets for customers. As part of this I want to import the description of the hotels from DB1. I have tried to do this using a...

I'm having problems today getting my head round a new DB. Basically the database will power nightclub guestlists. So far I'm thinking 3 tables... Town Club Customer I need to be able to add new towns and clubs on a weekly basis (no problem). When a customer phones to book I need to I need...