Microsoft Access / VBA Forum

Not sure what happened, but cannot figure out why its not working at this point. I attached the database so anyone willing to help might be able to tell me what went wrong and what I can do to fix it. Thanks for any help provided.

I find it useful on occasions to sort continuous subforms in date order, with the latest date on the top, and the blank new record line above the first record as per this illustration. https://bytes.com/attachment.php?attachmentid=9683&stc=1&d=1536090429 Basically it consists of a standard continuous form, but with an identically formatted...

On my form, I have a SSN and name field. If the SSN is blank, in the On Got Focus on the name field, it looks to see if SSN exists (did it on next field per suggestion from another person). If it exists, it asks the user if they want to go to that record. Yes opens another form, No closes current form and goes to main menu (this works fine). If...

This is my table named "Company" ID...........Company Name.........Logo 1............Mr. Book.............Image I want to show my "logo" on my whole reports. For this purpose I have used DLookUp function which is given below but it works only once. After re-opening the database has shown me an error "Run-time error '2220'. What should I do...

ProductionLost: Nz((+)*,0) I can put in the format as Standard, but it will not allow me to change the decimal place. What did I do wrong? Thanks for the help.

I am trying to use the Instr function to find all six possible combinations of 123, 213,213,312 and 321 using this sql script: SELECT WaltLottery.DTE AS TargetDates, WaltLottery.Cash3eve, WaltLottery.Cash3nite FROM WaltLottery WHERE (((WaltLottery.Cash3mid)=InStr(,))); I get no data outputted and no syntax error. but when I run the near...

one of my clients want lot of data but only in 1 row, the screens width property won't let me change to wider than 22 inches. is there somewhere to change this?

Hello. So, I am a logistics engineer and I am trying to help my pricing manager build a pricing application tool that will help eliminate her time spent filling in huge excel files with information about pricing bids. I have successfully build an Access form that fills in the areas she wanted filled in but I come across a new problem now: ...

Hello, I am new to MS access and having trouble to find a way of managing the following: I have a "main table" (tblProjects) and 3 "detail tables" (tblSchedule, tblCosts, tblResources). Those 3 detail tables have the "projectID" as foreign key. I have main form (frmProjects) with a subform showing a project overview (datasheet view)on...

I have a warehouse database. I have created a query which searches the table for duplicate serial numbers and give me a warning message, that works. My Code Private Sub SerialNumberTxt_BeforeUpdate(Cancel As Integer) Dim Answer As Variant Answer = DLookup("", "InventoryTransaction", " = '" & Me.SerialNumberTxt & "'") If Not IsNull(Answer)...

The need for Access and Outlook to talk to each other is inevitable. There are plenty examples on the web if all you are doing is working with your own e-mail account, but when you need to work with Public Folders, the examples get increasingly difficult to find. Hopefully, this post will make it that much less difficult. In the past, all I had...

Hi, I am facing an unusual issue with my Access 2016 VBA code. I have a Form with a field called txtUID. I'm using the Form_Load sub to initialize this field as follows: Me.txtUID.Value Format(Date, "dd/mm/yyyy") In a separate module sub, when i use this... tmpTimeStampUID = Me.txtUID.Value, i get the error INVALID USE OF 'ME' KEYWORD.

I tried to incorporate some code I found online. I keep getting runtime error 287 when I attempt to save the email to Access. Thanks in advance for any advice. Private Sub cmdSave_Click() 'I got the guts of this sub from Remou on tek-tips.com. S/he told me I can drag and drop an 'email to a memo field, then gave me the object...

I am looking around for an MS-Access based database that will help me manage the collections of Ksh.3000-50000 small loans. I need to be able to create amortization schedules when the loan is first made, and then I need to be able to apply payments to principal and interest as the payments come in. Don't need multi-user capability or Web...

If date acquired is greater than 15 days, I want to exclude that month using the below expression E.g. If on 16/1/2018 an asset was put to use, the monthly depreciation will start February rather than January since the asset was put to use above 15 days of January: I have this expression which I want to incorporate that please help....

I am trying to use the where condition to assign the caption to the form I am opening through DoCmd.OpenForm triggered by command button OnClick. This form is a template I assign 4 different record sources (you'll see in part of the code), the caption in property sheet is blank. I would like it to show me different captions depending on the...

I have a extensively calculated field in a report which would take many queries to reproduce. I need to take the existing reports' calculated field and store data for further use. Is there a way to accomplish this?

Hello all, I am trying to make a macro run nightly. I have a task scheduler to open the database, and on the opening form I have put a time interval code set. However, I am unsure what time interval amount I should put. Let's say I put 6000. Upon testing this, it printed the report continuously every 6 seconds. How can I make it run just...

Creating a database to track training. I have a form in which an original certification date is entered. From that date, I need to add 1, 2, or 3 years to determine the due date for re-certification (a separate field) based on the button that is clicked ("1 year", "2 year", or "3 Year".)

Hi I'm a newby . Created a from via wizard with two combo boxes. In the first user must select a Customer. Based on first selection, second combo box displayed Material List of selected Customer again for selection. This is all working 100% Problem : I want to force user to select a Customer in first combo box. If nothing is selected, the...

As of today my Access will not let me add anything to any form. I can click on text boxes and make changes but if I want to add a line when I click at the end of a line and press enter I don't get a new line. This must have something to do with my database as it's happening in Access 2007 and Access 365. I'm at a loss as to what's causing this....

Hi, I have some reports in my database where i put the following VB code to display a No Data message. Private Sub Report_NoData(Cancel As Integer) MsgBox "There is no data to display", _ vbExclamation, _ "No Records" Cancel = True End Sub The code works fine but after getting the Message "There is no data...

I have a split database. Back-end is Test.mdb and the Front-end is Test.ldb. I made a copy from one system and saved it to another system running a different instance of Access. When I try to run a specific query I get an error saying the 'format' function is not recognized. The new instance is Access 2016 version. Any suggestions for fixing...

I have a split database where the data file is located on the server and the program is located on individual workstations. We are getting the following error message on all machines when we try to open the program "Unrecognized database format '\\RWT-FILESERVER\Public\Documents\RWT\Documents\Company Database\Company Data.mdb' We cannot...

How do I select a record in my access database viewed on the web and display the contents?