Search results

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

Your Datasheet is your RecordSource in the form, your criteria is your Filter, and you may be using Order By. Those parameters are addressable and can be captured for use in a dynamic SQL Statement. Then you can export the data in the SQL Statement using TransferSpreadsheet acExport etc etc etc...

I have a large database that I administer and there have been instances where the largest of the queries causes an error "System Resources Exceeded". Could this be an indicator of something like multiple queries attempting asynchronous execution when one is set to fire right after the other? I...

Doggone it and I had my rant ready to go then I read the rest of the story. I'll post it anyways for your enjoyment. (Postea de superiore sermone conscriptae) Well, I'm not sure who this is but I see The Doc Man with 9k+ Posts here and Eurisko with 9, I see over 400 Thanks for the HELP...

Answer I found by Doug Steele, Microsoft Access MVP I tried it and it told me in Hours, minutes, Seconds FormatDecimalTime(16.83) 16.83 hrs = 16:49:48 at http://www.pcreview.co.uk/threads/converting-decimal-time-into-hh-nn-ss-time-in-access.2793160/ So use it something like...

Implemented the proposed Fix and did C&R on both FE and BE Everything worked fine today, so, I'll just keep a watch on it for a bit. Thanks for the guidance, Cheers Goh