Search results

I got it to work but now i'm trying to do something else with it on another form but not having much luck. I have an unbound text box on an unbound form where I want to display number of business days from start of financial year to today. I tried =fNetWorkdays(1/7/2008,[today]) but I get an...

Thanks HiTech Coach!

I am a bit confused... I have copied the workdays2 code into a module and changed to suit my date fields but how do i use that module on my unbound text box?

Great!! Thanks Bob, Now i know how to format, i can use this for other things too now. Thanks Wis, but definately won't have more than 1000 records in a month. Thanks everyone for your help!

ok that helps me with the first part - so i'm keeping it as an unbound field but how do I get jsut the month part of date() and format it as 2 digits? Thanks.

I have read it but it didn't really help me. Yes I do want to store the concatenated result. Later down the track I want to be able to search by log number (concatenated result).

Thanks for your quick reply. That's how i was going to do it originally but how do i get the data back into the table if the control source is being used by the code? and also how do i format the numbers so that they are 2 digits for the date & 4 digits for the record id?

Hi, I’ve usually got a basic idea with access but this one has me stumped… I’ve got a text box on my form that I want to display a log number for each record. The log number should consist of the state (which is selected form a combo box on the form, the current month (month in a 2 digit...

Thanks!! The bound value code worked great!!!

Please help... I've never used Dlookup before and i'm not quite sure what i'm doing. I have a form where you enter details for a quotation to give to sales. You select a salesperson from a combobox and upon pushing a button i want to be able to send the quotation report to that particular...

The subform doesn't have a query. It's record source is a table. Is there any other way?

Hi, I am trying to sum the total of a column (linetotal) on a subform and have the result appear in a text box(total) on my mainform. The control source of [linetotal] is [qty]*[unitpr]. I have tried a few different ways and still can't get the result i want. I can get the [total] to =...

Hi I am building a form to be used for ordering. the main form contains a subform that I am having trouble with. On the main form I have my employee information - name, branch, department. On the subform I have the product info - prod code, description, price, qty, etc. The control source...

Will this work if I have to change the file type as well when I save as?

I'm after an access code to open an excel spreadsheet and save as another name than close the spreadsheet. My spreadsheet is located in I:\Databases\StockDB\SarkoezyTemp\NswStoresOM2.xls Can anyone help please?

This is what my joins currently are: INSERT INTO [Stats Table] ( [Date], Overcommitted, [Delivery Confirmations], PHistory, DCHistory ) SELECT [Count Del Confirmation for Stats].Date, [Count Overcommitted for Stats].Overcommited, [Count Del Confirmation for Stats].DelConfirm, [Count PHistory...

I've got an append query that appends 1 column from 4 different tables into 1 table daily. It works fine up until 1 of the tables has no data in it, than it does not append any of them. Is there a way to get around this? Thanks

I have a code that emails a query as an excel spreadsheet. I want to be able to add more code at the start to tell it: if no results in the query than don't open the email window. This is what i have so far: Private Sub Send_TAM_Button_Click() On Error GoTo Err_Send_TAM_Button_Click...

I have a table of data that I would like to send as an excel spreadsheet as an attachment via email. I want to be able to do this by clicking a command button. In a second table I have all the employees email addresses that I want to send it to. I also don't want everybody to get the same...

I'm making a report at the moment and in one of my text boxes i want to retrieve information from my form's combo box. On one of my form's text boxes i'm able to put this into the control source: "=Salesperson_combobox.column(2)". Am I able to do the same thing on my report for a differnet combo...