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

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 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...

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...

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()...

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...

This is probably pretty simple but how would I code the click event to select all the data in that field and copy it to the clipboard, (I'd like to be able to paste it into another application with the Ctrl V method and I have to do this hundreds of times so it would help if I didn't have to...

Okay...I've got my access data entry form on top by using the following code... http://support.microsoft.com/default.aspx?scid=kb;en-us;101325 however, If I want to enter data into that form, when I click on it, the app reappears and blocks my view. I had read a thread somewhere that talked...

I am thinking there isn't, but does anyone know of a way to keep a form visible in other applications. It would be useful for me if I could set a form to "always be on top" of other applications. That way I could browse the web and easily enter data there etc. Its a longshot I know, but just...

Currently Using Access 2003. The database is growing and our company is going to be around for a while. I know my Manager would appreciate the dependability of SQL better than just keeping our Data in access as it is buggy. Is it possible to convert the data to SQL but maintain Access as the...

Hi, I have a database secured by the SHIFT BYPASS methods described in the following post thread181-785175 Unfortunatly, on a PC that is set up with Windows 98 and Access 2000 the SHIFT BYPASS thing works, but if I try to open the DB on my Windows XP Access 2003 machine, the database opens...

The Below report asks for a value each time it is run. (A transaction ID) How do I pass that value to it programatically as opposed to typing it in in the input box Access provides? Private Sub Command907_Click() DoCmd.OutputTo acReport, "CreditCardReceipt", "HTML _(*.html)"...

Does anyone happen to know a way to generate an email out of access with an attached report as a PDF? Begginer here. Any help would be appreciated.