Search results

Hi all, I want to rename a table field in VBA after import but I don't know the field name, I only know it's the 4th field in the import xlsx file that changes daily. Any help please?

HI all, I'm opening a browser at a specific page from the form using the following VBA. Just wondering if I can stop the field from being a hyperlink if the value is NULL? CreateObject("Shell.Application").Open "http:/google.com" & Me.OpenURI thanks in advance.

looking for some help, please. I've got 4 fields [firstName] [Firstname_formal] [Lastname] [Lastname_formal] Some users will have a formal name (could be one or both) but prefer to be called something different. John | Soon | Downer | Tzvetozar Pam | Pamila | Downer | Jan | | Smith | Jones...

Hi all, I need help with calculating a field value please. I've got 5 products, numbered 1 - 5 in tblProducts.productID In one order I'll only ever have the 1 - 5 products, with a maximum of 5 products in any Order. products 1 = mushroom 2 = tomato 3 = egg 4 = fish 5 = meat tblOrder.orderID...

Hi, I have a continuous form with the recordsource from a query. I have a Unbound textbox and would like to search on more than one field which is what the below code is currently doing. other field names - jobNumber (number field) - suburbName (text field) - jobInformation (text field) -...

hi all, I'm wanting to open a record in another database, below is the code that opens the form to the correct record in the DB I want to open. can anyone shed light on code required to do this please? Private Sub btnDetail_Click() DoCmd.OpenForm "fJob", , , , , , Me.Name...

hi All, newbie needing some help please? I found the vba to generate multiple pdf's from a single report which is working well (see below). The script below generates about 15 pdf files and stores them in the specified directory I'd like to be able to now email these to the individual users...

I've got a subform that has a filtered combo box based on another combo box and are getting a parameter error on loading the form through the Navigation Form. Main Form = ProjectMain SubForm = ProjectDetails Combo Box = CompanyIDcbo I've tried the below combinations to get it to work but no...

I've got this currently where I'm summing multiple orders for an project ProductSubtotal: Round(CCur(DSum("[TotalOrderDetail]","OrderDetailsQuery","[OrderID] =" & [OrderID])),2) my problem is if an [OrderID] doesn't exist, then the Nz function still won't work for me and returns #ERROR I'm...

I've got a Navigation Form set up and are looking to requery the subtotal of one of the forms AFTER I have added data to a subform within it. (Image zipped) The subform requery's the totals ok when I add a product, just can't seam to get the form to requery without having to put focus on the...

New to Access I've done a lot of searching before posting, but aren't searching on the right terms I guess. I've got basic relationships established on tables which works in most cases. My concern is when I build a query those relationships are established in design view. The information...