Search results for query: *

From Customer Inquiry form, I want to copy mainForm frmCustInqPOLog2 with subform sfrmInqSubTBL1. There are QNo fields which are text type on mainform and subform and they are Primary Key as well (table InquiryLog and InqSubTBL1). When I click "Duplicate" command btn from main form, I want to...

Hi, I have small inventory system using access. When I create an invoice, shipp q'ty is subtracted from inventory. What I want to do is if q'ty is 0 or less than shipQty, give the warning message and not to allow to create an invoice until inventory has enough q'ty. For an Invoice...

Hi, Is there any way to refresh DLookup function in my subform ? I have a main form(frmQchart) with a sub-form(sfrmSIsummary) with datasheet format and I'm using DLookup to bring up few fields (fob1,fob2,,,) from tblFOB. Once I brought up the fields from sfrmSIsummary and change the data...

Hi, Subform refresh problem. I have a main form with data sheet sub-form. There is a SPN combo box in sub-form to bring up part number if it is registered. If the part number is not registered yet, open part number registration form. My problem is after register a new part number, it...

Hi, I have a comboBox for part number and set to LimitToList "Yes". Following is my NotInList Event Handler. If the part number hasn't registered yet, click Yes, then product registration(PR) form's opened and register part number. My question is that when the PR form's opened, new part...

Hi, I have QNos in table tblShop, data type is text 1 1A 1B 2 2A from my query, I want to sort QNos like 2 2A 1 1A 1B I tried ORDER BY Val(tblShop.QNo), tblShop.QNo DESC; but it tells me "Data type mismatch in criteria expression." I need some help.

Hi, I want to put my own error msg to my combo box. I have a combo box and set the Limit to List "Yes". When a user put the product type which is not from list, it gives an error message. I gave the error msg to "On Not In List" under event procedure but still I'm getting automatic error...

Hi, I want to sorting 2 columns in order but only one column is sorted. I need someone's help to figure it out. Here is my SQL statement. SELECT QNo & [QNoRev] AS QRev, InquiryLog.InqDate, InquiryLog.ProducType, InquiryLog.InpuType, InquiryLog.TotalWatt, InquiryLog.OutputType, ...

Hi, I want to combine two different types of columns into one. QNo is a numerical, QNo Rev is a char type. The columns are like following. QNo. QNo Rev. 1000 1000 A 1000 B After combining, sorting is 1000 1000A 1000B Any help will be appreciated.

I have an Invoice form with Invoice detail subform. Once the Invoice form is created, I want to "POST" it to protect changing further. When the invoice form needs to be changed, I will give a revision field. Ex) Invoice Number : 1000 Changed after POST : 1000a Any suggestion ? Thank you.

I have a command button to send E-mail using Outlook from Access form. Question: I want to include only lines filled in. Following is a part of my code, it includes all of lines in the form. Example) Sometimes, we do have Output Type and Output Volt but sometimes don't. Private Sub...

I have a form with a subform (datasheet view). In the subform, there are BallsIn, AM's Job, PM's Job, and Customer fields. I gave Open Issue field instead of 3 fields (AM's Job, PM's Job, and Customer). So, if BallsIn is "AM", it corresponds to "AM's Job". BallsIn Open Issue(AM's...

I have two tables and one form. Table Form 1. tblCustomerOrderLog -- frmCOL (it is datasheet view). 2. tblCustomer has fields, CODE, PaymentTerms ... On the frmCOL, I put CODE and PaymentTerms to display data. CODE field is a combo box that I can choose the customer code...

My Query result is something wrong. I want to get results; Query 1:(([InvDate]+30(days))<=[CurrDate])AND[Paid]Is Null Query 2:[CurrDate]>=[Paid] Following is my Query example for 2nd one but the result isn't that I expect. FROM tblCustOrderLog WHERE...

Hi, I have unbound ComboBox which displays several columns on "frmInvoice" form. When a user chooses a "Company Name" from combo box, the several text fields display the associated address. The unbound Combo box AfterUpdate() codes are following. Private Sub Select_a_Customer_AfterUpdate()...

I want to save a form to different table. There is a form "frmVendorInq" base on "tblCustomerInq". After I enter data to "frmVendorInq", I want to save the form to "tblVendorInq". I put "Save" command button on the form and default code came in the follwoing. DoCmd.DoMenuItem...

Hi, I want to bring "Invoice" form with old information and save it as a new "Invoice" with a new Invoice Number. I gave unbound combo box to bring the old data from Inovice table but I can't change the "Invoice" number because the data type is set to "Autonumber". What do I have to change...

Hi, I have "Run-time error '3075':" Syntax error (missing operator) in query expression '[TPbaseNo]=P4230P-1F'. I have a 'Product Info'(main form) with 'frmProductInfo' (sub form). Following code is in my subform 'On Dbl Click' event. Private Sub Form_DblClick(Cancel As Integer) Dim...

Hi, I have a problem on my Invoice form with subform. After I create new Invoice, I got a following message. "You can't go to the specified record." If I click "OK", then it says "You can't save this record at this time." If I click "Yes" and close the form and go to Invoice table, the...

Hi, I'm sending e-mail from access db. I have to use HTML code in my Outlook form such as bold type, center adjust the text ... Does anyone know how to enable HTML processing in email from access form ? Example) strBody = "<Center><B>This line for Center and Bold Text</B></Center>" Thank you.