Recent content by punky

I want to display all records in a recordset. The recordset is named Cemetery and has two columns (cemeteryname and code).

on opening a form in vb.net, how do you show all items in a list box. What is the sql statement?

Trying to bring in Exel Spreadsheet, but statement tries to find file in D Drive when I am in O Drive. Statement reads as follows: DoCmd.TransferSpreadsheet acImport, 0, TableImported, TableImported & ".xls", True, ""

Hi FancyPraire, Am I mistaken or does the code you suggested to disable * Disable Privileged items from Menu bar(s) * disable all across all access databases in your windows applications. I found that using this for i.e. Tools on the Menu Bar disables Tools on all Menu Bars in all Access...

I pulled the .setfocus from somewhere here in tek-tips. I am not the originator, but it works great if your use setfocus before setting the listindex. Me.cmbBus.SetFocus cmbBus.ListIndex = 0

I am not sure how the data for a check box is supposed to appear on a report. The check boxes on my report show nothing even though many have a check mark indicating a yes answer on the form where the user has checked them. Do I need to put code behind the report to make the check box field on...

mrf1xa, Thank you. Obviously, I have been at this pc tooooo long today. It almost hit me on the head. It works great.

I am on Forma. I open formb and have both forms in view. I run a query in formb that will update the table that is the source of formA. I put the following code in the close event of formb. When I hit the close button on formb I get the message that another user has updated the record do I want...

I have a mainform with 3 subforms. How do I tab to a SPECIFIC FIELD on the 3rd subform after leaving the 2nd subform. I have no trouble tabbing from subform to subform but I cannot get the code for moving from specific field on a subform to a specific field on the next subform. Also, I have...

I have to develop a database to be used on a laptop. The database would be used by only one or two people at one time. Eight(8) records totaling 818 positions (length), with an estimated 1/2 million records total. Looking at Access and SQL server. Any recommendations, suggestions on whether...

HI ToeShot, I finally got the stlinkcriteria to work for two criteria, but I do not know how to extend it to four criteria. The following works great, but I am still not sure about the groupings between the double and single quotes. Obviously, if I take enough time I will figure it out, but I...

I have a report with several sub reports. These reports need the tables with at least one record in them so the sub reports will reflect 0 in necessary fields. If no tables exist for the sub report, that sub report doesn't show up on the main report. I don't want the report to be half there...

I need to maintain the records in the table, so I do not want to delete them.

I want to set the values of all the fields (records) in the table to spaces or 0 accordingly. Can I do this with a single line of code or do I have to address each field in the table separately to update it's contents. I am hoping there is an "initialize" piece of code to do this...

I took the next example off this site but is does not work. Can someone tell me how to string 4 keys together to make the stlinkcriteria work. I do not know what double quotes go with what single quotes and so on. Dim stDocName As String Dim stLinkCriteria As String stDocName =...