Search results

I was wondering when the open table issue would come up.:) The problem is that I need a generic solution for tables with identical first three fields but variable names and numbers for the remaining fields. This is because each installation of the application will have different contents for...

Either I'm thick or I wasn't clear. Here's the context in which I'm trying to freeze columns: DoCmd.OpenTable "BB_Download", acViewNormal, acReadOnly DoCmd.RunCommand acCmdFreezeColumn in which case any subsequent command beginning with Me. throws the error "Invalid use of Me keyword." George

Thanks, Bob. But I'd skimmed that page already and didn't pick up a "how-to". Issuing the command three times doesn't freeze any more than the first column. g

Assuming a table is open in datasheet view, read-only, can one freeze the three leftmost columns? I can freeze the leftmost with DoCmd.RunCommand acCmdFreezeColumn But three? Thanks in advance. George

Here's the function that makes at least one file that can be imported with the TransferText method. Function MakeReadable(Filename) As Boolean Dim strFIn As String, strFOut As String, btChar As Byte On Error GoTo MakeReadable_Error strFIn = Filename If strFIn = "" Then...

The application is constructed to apply to a single instructor's instance of a class. For each instructor the file I'm trying to import will be imported once. The inconsistency is between instructors. What I thought I had solved, but am still fine-tuning, is a byte by byte conversion of a...

Removed to correct errors. gwb

I was afraid of that. Oh well. Since the application is for instructors of MS Office they ought to be able to handle it! All it takes is RTFM. George

Unfortunately, import specs won't help in this case. The application is designed to import a set of graded items from some course management software (Blackboard). Each instructor may have a unique set of graded items, so there's no consistency in imported fields. (In fact, the graded item...

In Access 2007: I'm attempting to automate the import of a delimited text file without success. I can manually import the text file with the wizard without problem. When I use the command DoCmd.TransferText acImportDelim, , "BB_Download", strFileName, -1 where strFileName is obtained thru the...

All it took was an easy copy of the table with structure and data to make it local rather than linked. gwb

Kiwiman, Another dope slap at this end. The switchboard table is not included in the front end. Now to figure out how to get the switchboard table into the front end, assuming this is possible. Thanks for your very rapid reply. George

In ACC2003: I've developed an application with a front end & a back end. I made some modifications to the app, amongst which were two new switchboard menu options each running some vba code. I zipped the front end and emailed it to my client. When they run the front end, these two options are...

Guus: Probability = 1. Thanks immensely. gwb

I've borrowed some code from lala posted recently to enumerate the rowsources in table fields. The piece I've got: Public Function HasProperty(obj As Object) As Boolean 'Purpose: Return true if the object has the property. Dim varDummy As Variant On Error Resume Next varDummy =...

Vonnie, Thanks for the lead. I've not used vba in Excel before, so it'll be another climb up the learning curve. Oh, well. ON BELAY! The result: created functions in Excel to return and set the color. Hardest part was learning how to make the functions work in excel! Used the MS Excel...

I've just learned that my client for whom I'm designing an Access app to replace their Excel spreadsheets has assigned significance to the color of the row. My original plan was to pop the spreadsheet into a table and distribute the data from there. With cell color being meaningful that's...

OK, so I'm dense. One MUST use the appropriate naming convention for the text box, altho' the video seems to suggest that as long as it's three characters it'll work. When renaming to txt{name} we're back on the air. gwb We now return to our regularly scheduled programming already in progress.

I'm trying to use Uncle Gizmo's calendar in an ACC2000 application. I've found that if I configure an OnClick event in a text box, I need to comment out the line that begins: mHasPBkProc = fProcExists... in clsGetActiveFrm in order to make it work. Otherwise I get a Sub or Function not...

Learn something new everyday. Just wish it wasn't so painful. The reason for the invalid reference was that the form was not visible! I never realized that visibility was required for subform references to work. Now I do. Thanks for listening. We now return to our regular programming...