Search results

HAPPY NEW YEAR TO EVERYONE May the New Year brings you good code and prosperity.

ico or bmp should do.

Per gemma-the-husky's suggestion in your exampl1 above, the split function should to fine. I copied and pasted the names below into cell A1 on an excel sheet. Run the VBA below using the split fucntion. Amn Smith, John D SSgt Worker, Joe C Sub PerformSplit() Dim i As Long Dim...

Access 2003 - Not sure about Access 2007 Here is a quick code to reset all Access menu items. To hide it is just the opposite. Private Sub cmdReset_Click() 'show all the tool bar menu DoCmd.ShowToolbar "Menu Bar", acToolbarYes DoCmd.SelectObject acTable, , True For i =...

File => Get External Data => Link tables Browse to the ASK_dbase then select the table that you want to link to. Once that is done, the table should be more like a local table. You, then, can use the query I provided earlier to insert records. You should have both tbl_student and...

Here is what I did for a small app that I have. The is a modification of the Asset Tracking database. in the Switch Board module, I implement the following. Private Function HandleButtonClick(intBtn As Integer) ........ Select Case rs![Command] ' Go to another...

The easiest way I can think of right away is 1. Link the tbl_student table from the Ask_dbase to the current database where you do the search and double click. The link table in this case should be tbl_student1 2. Since both tables are identical, you can just use a simple SQL statement...

This forum is a great place to get your questions answered. Feel free to contact me if you need anything. I may not be the best programmer out there, but I will help you to the best of my knowledge. EZfriend.

I forgot how the scanning system work, but here is something that I did a while back. We use to read those card reader. When you slide a card, the reader will display the card number on the text box. on the Change event for the textbox, check for the length of the card number (my case 12...

You need to some how create a way to load the form database based on an ID or something. When double click on the ID, just reset/reload the form with new data based on that new ID.

If it is that simple, I can create you one. The chances are that your call program might get bigger and bigger. What are your criterions? Ezfriend.

Now the mystery is solved. I do not use an ADP and the BE is just another Access file. The reason I ended up creating the application this way is due to the number of active connections to the BE database that keep locking records. I ended up wrinting some classes that handles data...

That doesn't seem to work. I am assuming that your form is bounded to a table and that's probably why it doesn't work for my scenarion. My report is based on a ADODB.Recordset and when I set the record source the recordset (m_rs in this case), I get the error Run-time error '13' Type mismatch...

I'll give it a try. The thread, just in case. http://www.access-programmers.co.uk/forums/showthread.php?t=161868

Are you trying to filter the form data with the value in the combobox?

I have a report that I want to run with a recordset instead of using query? The BE database is connected through a ADODB.Connection and BE tables are not linked to the front-end. It was done this way to prevent the number of active connections to the BE since we have so many users using this...

Can you create a text object on the report and set its control source to "=sum([TheFieldThatYouWantToSum])"

1. You can include a RunCode line in your macro and call a Function Name something like ExportMyFile() Public Function ExportMyFile() 'export as excel file DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "qryThatRetrieveMyInformation", "c:\temp\out.xls", True...

If you can't open it, but the front-end still able to access the database, you can easily import tables, queries, etc into a new database and use it that way.

First thing comes to my mind would be to create a view (query) that display the information you need for that sub-form. When user enter a date and LOST_FOCUS/Enter/Exit the field, modify the query def to something like this e.g. SELECT * from vwVBook where BookDate >= #YOURDATE# Then...