Recent content by GohDiamond

When you link a an ODBC table to MS Access you are asked during the process to Select a Unique Record Identifier. If you do not select one of the fields then the table will not be updateable. Why didn't you select a field? Perhaps you don't know which one to select, OR You may know that...

Application.GetHiddenAttribute(acTable,"YOURTable")

Hello, I'm working with several network printers. I'm trying to get access to Printer Properties to set up the Locked Print option as some reports are to be sent to SPECIFIC Printers, not the user's default printer. I'm trying to set this programmatically using VBA. The Locked Print function...

If you need a specific output format: format(cdate("09 april 2016"),"dd/mm/yyyy") = 09/04/2016 format(cdate("09 april 2016"),"mm/dd/yyyy") = 04/09/2016 format(cdate("09 april 2016"),"m/d/yy") = 4/9/16 Cheers! Goh

If there is NO DATA to support the chart, it generally will not display. Either the source for the chart is empty or missing, or the link to the record source may be incorrectly defined.

First of all that behavior is what RECORD Locking is supposed to do. Prevent simultaneous editing of the same record by multiple actions. One question would be WHY are 2 people trying to update the same record at the same time? This may be an issue of data and how/where it is stored in the...

Open your csv file with Excel Check for Duplicate IDs in Key field if your table Key field does not allow duplicates Check for String Length in the original that exceeds the set Field Size in the Table Check for Date entries that do not match the Date Format in the table Check for Null value in...

Does each IMPORTED record have a unique transaction ID?

Thanks Colin I can't use any outside tools or addins, this is a state government controlled project. You know how that is. It would take forever to get funds or approval to use anything I didn't create. I'll look into the links you've suggested, but still hoping to figure out how to gain control...

Ok Back for more help I can get to the names of the forms that way dbx.containers("Forms").documents(Number from loop).name BUT I can't open the document/Form to get information about the controls. I need to do something like this: Dim appAccess As Access.Application Set appAccess =...

Doc_Man 1) yes there are quite a few forms in the remote database that I'm connecting with 2) I want to get the names of the forms, so that I can open the form and programmatically pull other information like recordsource, controls and control types etc 3) That's what I was trying to find out...

:banghead:I'm trying to connect to a 2nd MS Access database in order to get to the Forms collection When I'm connecting to a 2nd database with no security, no password, I can use: strPath = "C:\Path\To\remote\Database.accdb" Set appAccess = CreateObject("Access.Application")...

Do you mean to have each comma separated item on a new line? strResult = strResult & !f1 & ", " & vbLf and then strResult = Left(strResult, Len(strResult) - 3) Otherwise, what pbaldy said Cheers, Goh

Your single QUOTE has to be a STRAIGHT Quote/Apostrophe. Copy one of the straight quotes from the left side and replace each quote on the Right side with a copy of it. Chr(39) = Single straight quote mark/apostrophe (') Best to edit it in notepad which used STRAIGHT Quotes exclusively. Cheers! Goh

Addressing a field on a subform Forms!Mainform!Subform1.Form!ControlName Here's a bookmark for you for future reference: http://access.mvps.org/access/forms/frm0031.htm Cheers Goh