Search results

Hi, I am trying to copy from one workbook and paste into another workbook but keep encountering a Runtime error 1004 PasteSpecial method of Range class failed. The workbook I am pasting into is protected and I don't have the password to unprotect so not sure if this is causing the error? I am...

Hi, I am an amateur with Recordsets and looking for some advice. I have a table that lists some order numbers. I need to create a recordset which will add sequential numbering to OrderLnID, 1,2,3,4, etc for each record then reset to 1 each time the order number changes, similar to below table...

I need to design a table or query that can be exported to excel then copied into a write protected upload spreadsheet. The fields in the upload spreadsheet are: Order# Sequence# SKU Qty The sequence number is 1, 2, 3 , etc for each SKU then restarts at each new order #. I can't figure out...

Hi I am trying to convert a week which is entered in a text box on a form to the first day of the month in which it falls. My text box (txtdw) is in the format yyww and I want it to be converted to 01/mm/yyyy. example: 1401 would convert to 01/01/2014. 1406 would convert to 01/02/2014. I...

Hi Guys, I have a mainform and a datahseet subform. Mainform = FrmProj_ProjectEntry Subform = FrmProj_ProjectEntry_Sub1 On my mainform I have a text box (FrmProj_ProjectEntry.txtDueDt) where I enter an expected date. On my subform I also have a textbox (FrmProj_ProjectEntry_Sub1.txtDueDt)...

I have an unbound form which I use to enter a parameter for a pass through query. I enter the PO# in a text box and press the command button, the pass through query then appends all records for that PO# to TblPurchaseOrderData. I also have another table - TblAddress where I store all the...

I'm hoping someone can help me find a simple solution to this. I have a pass through query in my Access database where currently i have to open the SQL to change my date criteria. SELECT DATANS.POOMST.PKORDN, DATANS.POOMST.PDORDD FROM DATANS.POOMST WHERE DATANS.POOMST.PDORDD = '20130109'...

Hi, I am trying to find a code that will result in the working date 2 days from the current date excluding weekends and holidays which are listed in a table called tblholidays. I'm pretty sure the code below is what i am after but i am just not sure how to incorporate the holidays table into...

Hi, I've searched loads of forums today trying to find a solution to this but am finding myself getting confused and not getting anywhere. I want to be able to double click a record on Mainform1!Subform1 which then opens Mainform2!Subform1 and filters for the record that I double clicked on...

Hi I'm using code in an Aceess Database to export a query to excel then format the spreadsheet. if i run the code once, it works fine but if i run it again i get an error message - "Run-time error '1004': Method 'Columns' of object '_Global' failed. It hangs on: j =...

Hi, I'm trying to make a line of text in an email bold. I've searched heaps of other threads and found lots of info on it but still no luck. I've tried .fontbold = true and .bold = true. I want to make the line that contains SigFname and SigSName bold and all other texts normal. MyMail.Body...

Can someone give me a hand with this one... Not sure where my speech marks should be? =DCount("[id]","[qrysso]","[Month]=" & Month(DateAdd("m",-1,Date())) And "[Year]=" & Year(DateAdd("m",-1,Date()))) Cheers

Hi I'm trying to do a Dcount on one of my tables but am having issues with date conversion from US to European. I'm running off dd/mm/yyyy everywhere else and this is the first time ive had a problem. The Dcount works fine if the DD is greater then 12 but if the DD is equal to or less then 12...

Hi, I'm trying to setup and email to automatically send on a specific date each month. Tehn once the email sends i want to log it in a table that ive created. I've got the email to send alright but once i get to the logging part i get an error on mymail.subject - "The item has been moved or...

Hi, Just want to get some clarification on whether or not it is possible to have a calculated criteria in the DSum function. I have the following expression as my control source in a textbox. Textbox returns nothing. If it is possible, can anyone see where i am going wrong...

A little help please.:confused: I have a form where i select a contract number(cbocmsref and a month(cbofldate). Once selected i hit a button and my report opens. i want the main repor tot be as per cbocmdref (i got this part working) and the sub report criteria to be as per the cbofldate on...

I'm trying to do a dcount if my date field is on or before today. The date in [reminderdate] is 01/07/10. So i'm not sure why it isn't counting it. if i change the date to 01/07/09 it works. i'm thing it is counting the date as a number? do i need to declare [reminderdate] as a date? If...

Hi, I'm trying to edit an existing record in a table with a date/time stamp once i check my check box on my form. I've been reading tonnes of threads trying to figure out where i'm gonig wrong but i'm yet to have any luck :mad:. I think i'm prettyclose though. Can anyone help? Dim TaskHistory...

Hi, I'm trying to do a cascading combo box from my main form onto my subform with the criteria as an iif statement. If mainform combo box = "NAT" then i want all records to be avaialble in subform combo box. If main form combo box = anything but "NAT" then i want it to limit the records by...

Hi i'm trying to design a combo box to be used as a date picker. On one form i have contract details with a contract start date(TxtBox1) and a contract finished date (TxtBox2). On a second form i select the contract # from a combo box 1 (CboContract) then in combo box 2 (CboMonth) i want to...