Search results

I am trying to build a personal check register application and I need to write a DSum statement with two criteria as the control source of an unbound text box control which give me a running balance and I can't get the syntax correct. TransactionAmount and TransactionNumber are both number...

A command button on my form runs the Shell function to open a PDF viewer which displays the PDF file associated with the current record. Dim strClickScan As String strClickScan = Shell("C:\Program Files\SumatraPDF\SumatraPDF.exe ""D:\Periodical Reference Index\" & txtRecordID.Value &...

I want to rename a report by clicking a command button on a form. I have this simple code in the click event: Dim strReportNameNew As String Dim strReportNameOld As String strReportNameNew = txtChangeTo.Text strReportNameOld = txtChooseReport.Text DoCmd.Rename strReportNameNew, acReport...

I often use a few special characters when entering data, characters not found on the keyboard and that cannot be entered by the Alt+keystroke method. At present I use the Windows Character Map to copy and paste them, but this is inefficient. I want to create small command buttons for each...

I am a VBA novice and am trying to create a simple household inventory application for personal use. I have categorized household items into Appliances, Furniture, Housewares and so on. A table called tblItemInfo includes the fields Category, Item, Location, Cost, TaxRate, and DeliveryCost. My...

I created a personal household inventory database for homeowner's insurance purposes. Each record contains data related to a household item such as a TV, table, etc. Each item has two associated .jpg files which show a photo of the item and related documents. These .jpg files are in the same...

I have a single table database that I created for my own personal use to store computer related information. I categorize this data by Topic, Primary Sub Topic, and Secondary Sub Topic which appear as combo boxes (cboTopic, cboPrimarySubtopic, and cboSecondarySubTopic) on my form. Each one has...

I have a single table database that includes the following fields: Supplier1, Supplier2, Supplier3. On my form I placed three combo boxes, cboSupplier1, cboSupplier2, cboSupplier3, each bound to one of these fields. When I drop down the list for any of these combo boxes I want to see all of the...

I created a database which contains the names of scanned magazine articles saved as PDF files. I give each PDF a descriptive name which I store in the Subject field. I placed a text box on my form to display the Subject text which is named txtSubject. What I want to do is place a command button...

I have a form containing a wizard generated list box that displays the "Subject" field for all of the records in my database and allows me to select any record for display. When I use Filter by Form or Filter by Selection I want the list box to refresh and display only those records in the...

I am experiencing an error message in an Address Book application I am working on. This application stores names, addresses, phone numbers etc. It also stores URL's to websites. On my form I have arranged my text boxes columnar style allowing me to tab down the page in a logical order to enter...

I am creating an application that prints label inserts for CD jewel cases. I have several different text layout styles that I use. For example, Style A, Style B, Style C, etc. Each style differs from others in its text box placement and graphical elements such as dividing lines. In my table I...