Search results for query: *

Is there any way to make the column headings in a subform in datasheet mode word wrap. I have several columnames that are longer, but the data is short and I would like to illimnate having to scroll over. But I don't want to use an acronym. Thanks

How would I go about doing that? Newbie here.

DoCmd.OpenForm "OpenIssuesDualForm", acViewNormal, "", "[Forms]![OpensIssuesDualFormQuery].Form![Support Contact]=[Forms]![Open Issues Dialog]![SelectEmployee]" I am trying to prefilter data with a form "Open Issues Dialog" that has you select ALL or choose from a list of employees...

I am a newbie, so this might be a totally stupid question... ON public variables... What happens if two users call upon the variable at the same time from different PC's? is that irrelevant?

I know it is possible to make enable and lock different fields programatically, but is it possible to lock or enable entire forms or subforms? Basically, I have some data that I would like to have entered before the user is allowed to move about fields on other subforms on the main form.

I'd like to lock down the steps of entering data. I have an unbound field in a form and a button. When the user presses the button I want the form to close, and a new form to open with that data now entered on the new form. How do I pass that data from the unbound field to the field on the...

Where is that meant to be placed? I tried putting that in the module and then typing x but it didnt' work

I get a Compile Error: Expected variable or procedure, not module error if I type it with quotes as follows: SaveAllAsText("J:\Shared")

I am trying to call the following function from the immediate window by typing" SaveAllAsText(J:\Shared\Orders) Anyone have any idea why this might give me "Compile Error, Expected, List Seperator or ) " The Code was taken from this post...

bboffin, I am typing SaveAllAsText(J:\Shared) in the immediate window and getting this error: Compile Error Expected List Seperator or ) Please help, this is exactly what I am lookin 4

thank you! those darn quotes get so complicated sometimes.

Thanks!!! Okay, so that works better now, BUT, when I try to reference tjfld.name in the INSERT INTO SQL Statement, it wants me to define each Field name as if it were a variable, instead of inserting the actual field name into the table. See DoCmd. Statement Public Sub ListTables() Dim...

I would like to loop the below code to go through a list of tables, but when I try to define the current table as a string and pass that varible into the Set tjTab =tjDB.TableDefs!MYCURRENTTABLENAME command I get a syntax error. (or, if anyone knows a really easy/clean way to get a list of...

Can I get a list of queries, fields, table, etc from Access without running that report. Meaning, is there a function that returns a list of queries fields, tables etc? The report is too cumbersome and requires so much formatting, I just need a simple list. Thanks!!

Hi, I am realizing that I need to learn how to create unbound forms. I know how to open a basic DAO recordset but have no idea how to pass those values into the fields on the form. Does anyone know of a good link that explains how to create unbound forms with DAO and ADO recordsets/ Thanks!!

I am trying to cross-validate data between different fields it works unless I am asking about Null Values Below is an example that would get me a "Runtime Error 424 Object Required". Sorry if this is something totally simple. Any help is appreciated Private Sub AutoEmailChckbox_LostFocus()...

I think you have to delete the image and put it in when you are done editing your controls (this is what I am experiencing too)

That worked perfectly. One last question. Do I need to close/clear out the recordset or anything at the end? Thanks for your help!!

Thanks for the help!!...its closer but.. It gives me a "Database or Object" is read-only error.

near the end of this code, right before the "ReceiptRequest.MoveNext" I need to say to update the recordset and set a the DATESENT field to today's date. Since I already have the ReceiptRequest recordset defined...how do I go about updating a field in that particular record in that recordset...