Search results

I thought maybe * might work, but nope, still no joy.

Hi All, I have a form that is linked to a query. The query filters the form by pulling criteria for one of the fields from a function. The criteria is fed into the function based on a combo box with options "Team 1", "Team 2", "All Teams". The issue I have is what to pass through to the...

You're right - there's nothing wring with the CSV file!!! It's Excel that's dropping the zeros. And I'm usually the first person to check the obvious first. Can't believe I've spent all week trying to fix that! Thanks for that

See this link for my solution: http://www.accessforums.net/programming/concatenating-criteria-query-help-31140.html#post153119

Hi All, I'm trying to output a table to a CSV file using TransferText in Access 2012. There are 7 fields in the table and they are all formatted as text. One of the fields contains a time that must be formatted as a 6 digit number - ie. 9am is 090000. When I export the CSV and open it in Excel...

Sorry, I was unaware of the courtesies when crossposting, I'll keep that in mind in future.

Hi, I'm trying to write some code that checks through a table and adds together criteria that is currently selected and then concatenates it to produce a string that is sent to a function and then called from a query. Hope that makes sense! The code is below: Dim rsSelectedGroups As...

I've fixed it! Sorry guys, it was the button. Well, it wasn't actually a button - it was an image with code in the 'click' event that was being used as a button. There must be a property in a proper button ctl that causes the current record info to be used rather than the first record. I new it...

ok, JHB, we're on the same wavelength! I've already rebuilt the subform from scratch and removed all the filtering and the refresh is also gone, but still the same issue! There's no other code on the subform. See attached for result...

There's definitely something strange happening! Yes, I've checked and it is the correct field name - I've questioned myself a few times and had to double check! I've inserted a MsgBox Me.CurrentRecord into the button code and it always displays record 1, no matter which record I click on. The...

Hi, Doesn't look like there's going to be any solutions forthcoming! To be honest I gave up with the OLE Object route and I'm just using links to the graphics instead. :banghead: This has worked out much better! :) Where I want an image to appear on a form, I create a picture box, but...

Thanks for your reply! I already have a refresh in there, but it's still not updating. Here's the code on my button click: Private Sub ctlEditButton_Click() Me.Refresh MsgBox "Project Name = " & ctlProjectNameTxt DoCmd.OpenForm "frmEditProjectWizard", , , "ProjectName = '" &...

Hi, I have a continuous form with a button next to each record. I want to open up a pop-up form that relates to that record when the button is clicked. I have all the correct code in place and the form should open filtered by the contents of the ProjectName filed. However, when the button is...

I know, I know - OLE Objects create huge databases! In this case I only have several very small images, so no problem with size. What I'm trying to do however, is insert an OLE Object into a table using VBA/SQL. Currently I have the following code: CurrentDb.Execute ("INSERT INTO...

Brilliant, that worked Paul! Thanks

Help - my DCount's not working! Here it is: Me.txtOrdersToday = DCount("[AccountNo]", "tblAccountBase", "[UserID] = " & UserID & " AND [AccountOrderedFocusThisP] = TRUE AND [StatusDate] = #" & Date & "#") This DCount returns '0', however, the following query returns '2', which is correct...

I'll remember that, thanks! Fortunately the graphics are all tiny and there's not too many of them, so I'm ok for size at the moment

Hi, Thanks for your reply. I finally figured out how to do what I wanted by entering the world of OLE objects! I've managed to get it to do exactly what I wanted - just a shame that the formatting controls are a bit limited - the images all come in left and top aligned rather than centred, but...

Hi, Here's what I'm trying to achieve: I have a continuous form that displays a list of records. I need to display a logo next to each record that relates to that record. The path to the logo is stored in the table and currently I'm using 'Me.imgProjectIcon.Picture = Me.ProjectLogoPath.Text'...

I found the editing record lock option! That seems to have done the trick. I'm no longer getting any errors - it simply stops the record being edited while the other user is accessing it. Thanks ever so much for your help guys!