Search results

Right ….i’ve been using this code to save and lock records that are finished…however it seems that ‘on click’ I’m locking all the records…including new ones…so I can’t create anymore. If I exit the form, go into design view or edit the code in some way..i’m able to create a new record and all...

yup....exactly what i was thinking... Sounds like a 'wizard' would be the simplest answer!!

Do you mean each employee has a individual form??? Or record?

hi i'm trying to allow users a selection in a listbox. However i have not used dynaset before, with the following code i get an error...'too few parameters, expected 1'......when i debug this it points to the line Set Rs = CurDB.OpenRecordset(SQLStmt, DB_OPEN_DYNASET) the value that the...

Okay I have the following problem …which I can’t even think how to solve…. I have an order table with a subform …’order details’..each line has an detail ID I need the order form to have the option to pick from previous detail ID’s (order detail records)…which will generate the chosen record...

Hi...was wondering if anyone knew how to shade colums in a datasheet..if its possible at all!!!??? Thanks for any replies S

Okay i've already mentioned this problem before...but its getting desperate!!!! Pleae if anyone can help i reeeeaaally need it now.. I have a successfully running database...but the problem is the reports... i need to generate these reports as they are currently displayed..in a format that...

thanks deborah..but the lines are VITAL to my reports!! does anyone know anything about PDF format..ie. how could i get the report to be saved and e-mailed in this format???? DOes anyone know???? That would keep the original format right??? The reports are quite complex...lines and all!!

thats just it...loads of our customers won't have it installed....and my boss is 'insisting' he can't coope with any other format .. :o( Is there no way that i can use word?? Thank you so much for responding!!! Sarah

do you type the word dave into a field on your form??? or do you want it standardly automated for every new record??? ..if theres a few of you 'originators' you could create a drop down list for you to make a selection and that choice could be generated??? ...have all the time to help...just...

thanks alot!!!! but i'm trying to find a way to open the report directly to word, keeping all my report formatting (e.g. lines etc.) ...i think its got something to do with stopping it appearing as a rtf document???

okay...hopefully a really simple question....does anyone know how to attach a report as an e-mail attachment???? Thanks in advance!!! S

Okay, not sure I’m on the right track… But as said before your table should automatically update by designating the right record (control) source. Basically what have you built your form from….a table??? If so…if you have a field say…customer name ….if you go in design view of your form and...

thanks col..that did the trick!! For anyone with a similar problem heres the new code generated by the wizard Private Sub Combo239_AfterUpdate() ' Find the record that matches the control. Dim rs As Object Set rs = Me.Recordset.Clone rs.FindFirst "[InvoiceNo] = '" &...

Hi Col, .. no, that isn't it, but thank you for the suggestion!! ......when i debug the problem appears to be that the combo box is looking at the value of my primary key, ...which aren't the values in my combo drop down list!!! (did try your idea though!!) Sarah

Hi I have a problem, that’s been getting to me for ages. I’m trying to code a combo box to be a search field. I have used the following code successfully over loads of forms….where I’m searching for a primary key (which is a number) Private Sub Combo237_AfterUpdate() ' Find the record that...

thanks alot!! found it...

Hi, I’ve got a problem I hope will be really easy to solve…. I am hoping to number the items in a report. Basically if there are two records in the report detail I would want them numbered 1 and 2 and so on. Is this possible, if it is could someone please help!!! Thanks in advance for any...

Hi, i am completely new to filtering queries and wondered if anyone could help. I have a query that shows a 'product list' with their relevant serial numbers, what i am trying to do, is simply block two products from being displayed. I use product ID in my query yet display the product name...

THe only way i know to approach that would be to create a form from that table...do a search function on this. Have a look at Access help using the keyword 'bookmark' it gives you some example code which would work for this