Search results

What is the title of the one you are referring to? I can only see ones that do the number of days, not office hours.

I have created a new function that I think might be useful to other people. I am not an experienced programmer and so would welcome any thoughts on how this could be improved to be more efficient, customisable, or usable for public release. It calculates how many office hours are between two...

Beautiful thank you :)

I have a subform in datasheet view. On it I have an AfterUpdate vba sub, which includes a Me.Form.Requery command. The problem is this makes the cursor jump to the top left field of the table. I can make it go to the top of the column in question with Me.Quantity.SetFocus But is it possible to...

oh, haha thanks :o

Im using Access 2003

Finally found what I needed : Function FindReplace(strOrig As Variant, strOld As String, strNew As String) 'Function to search and replace characters in a string '----------------------------------------------------------- ' ARGUEMENT DESCRIPTION '...

It is removing the text qualifiers, but sometimes there are quote marks within the fields. Can I do a search and replace in VBA for characters within fields? I guess it would need to check each character individually.

I need to do it in VBA, can I do search & replace with that? The importing does remove the text qualifiers, but there are sometimes extra quote marks within the fields.

I am using DoCmd.TransferText to import a CSV file to a new table. The problem is some of the fields contain quotation marks which really messes things up for me later on. Is there some way I can go through the whole table and remove them? Maybe a Query? Or VBA?

Awesome thanks guys, I'm using DSum() and it works perfectly.

I have a strange problem. I have a subform which calculates 2 totals in its footer. I have a button on my main form which puts those totals into boxes on my main form. Everything works fine, unless I have over 15 rows in the subform! The button first does a requery on the subform I think this...

Sorry, I figured it out. The ones that were all changing were unbound. I added a field in the table for them (although its not really used for anything) and now they can all have different values! :)

I have a subform in datasheet view. On the AfterUpdate code the Markup field, it recalculates the ItemSell & GM1 Like so: Private Sub markup1_AfterUpdate() 'calc sell and margin(gm) Me.ItemSell = Round((Me.ItemCost * (Me.markup1 / 100)) + Me.ItemCost, 0) Me.GM1 = Round(((Me.ItemSell -...

Yes, thank you for pointing that out. I was doing it in a very retarded way.. :o

I am using the following code to copy a record, and open it in another form. I then want to clear some of the fields etc but when I do it does it to the original record in the form I have already closed! It says "The expression you entered refers to an object that is already closed or doesnt...

Beautiful, thank you!

I have some calculated fields in my form. They are Standard or Fixed format numbers, with 2 decimal places. But when I put my cursor in those fields they show lots of decimal places. Why is that and how can I stop it? In the attached database its the SELL, MARGIN, and MARKUP fields in the...

Now thats a good idea.

Well now I have it set up so that it opens the form and displays a msgbox. So the first thing u see is the msgbox that u have to click ok on. Only then does the Switchboard pop up over the form that opened. So at least the user cant miss the fact that he has unfinished work to do. It is very...