Search results for query: *

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

Thanks everyone, I agree with the reponses. The year is being used to flag year of a car on a database tracking vehicles. I will talk it over (AGAIN) with the users.

How do I either format or create an input mask that uses only year as valid input. The user does not want to enter month and day on the form. Do I change the table or the form or both and what does the format or input mask look like to accomplish this. At the table level, is the data type...

We are using Briefcase to keep Access tables in sync between laptop entries and original tables on the network. We keep getting this two way merge message when we try to update via Briefcase that says some laptop table entries were updated at the same time on the same date as the network data...

My access drive is mapped to another site. The access application transfers a table to another database when the application closes. It works fine from my home-side, but the when the user closes the application at a remote site, run-time error 3044 messages appears on their screen. How can i...

HI Throadbent(MIS), Thanks for the code, but when I used it I got "Method or Data Member Not Found". It is dieing on the data member, even tho I used the name of the field from the combo's source table. Any other method I could try? I am using Access 97.