Search results

Hi, I have a button with this event procedure behind it (i didnt write it i just imported from access 95) when you pressed this button - along with opening up the report which it still does it used to tick the box in the related table to say it had been done but now it is in access 365 it...

im clearly doing something very wrong because i dont even get references appear in the tools menu! :banghead: i do think the problem is with the translation from access 95 and it being less forgiving with the coding as it seems to be working as i am replacing vast chunks of it. Thank you for...

ok have totally recreated the form and the subform and as if by magic the broken bit now works ..... the bit that did work (feeding it into a report) now doesnt however :banghead: As for access 95 with password - yes i have one you can have BUT i have no idea what the password is .... i had to...

Hi Isla - no this isnt it, i understand how a subform works .... the problem i have is that the subform isnt updating the table behind it and i cant work out why i always thought it was an automatic thing.

Ok, i have very nearly figured it out but need you guys for the last bit. The sub form which is called "order items to deliver" should feed the information into the table which is called "order item header" but it isnt. when i add the information into the order item header table myself...

no the checkbox appears to be bound - i am pretty sure i have narrowed it down to the info on the delivery note not being saved. but dont know how to rectify it :(

I should add that everything is showing as it should on delivery notes that were done on the access 95 database so it is something in the transition that hasn't worked and im not sure what - although i cant find where the hell the information from the delivery note is saved .... or how it works...

Hi, Ok i promise this is my last post over this damn database (mainly because i never want to see another database again after this) :banghead: I dont know if it will be easier to send some wonderful person the database and talk them through the problem but essentially it is this: on the...

its ok fixed it - closed it down and reopened it! lol

Hi, really quick one - i have just gone onto my database tonight and all the button colours have gone .... not even the option in properties anymore .... any ideas? Thanks

oh i love you - i knew it was really simple answer i just couldnt for the life of me remember what it was ..... i am blaming a combination of baby brain (despite him being 18 months) and quitting smoking (8 days smoke free) Thank you soooooo much xx

Hello its me again with another stupid question - hopefully this is my last however. I have a report based on a query - within the query there is a parameter thing to ask them when they want the dates to start and end. When i put this into a report is there a way to display what they have...

woohoo it works thank you so so much xx

nope it has too many closing parathesis now apparently :banghead:

who knew trying to put a damn title on report was so bloody complicated! Please let me know when you work it out. Thank you so much

im clearly doing something wrong because i get #Func! when i do this. HELP .... sorry for being thick

thank you galaxiom - love you guys xx and june - i based the report on query that had Between DateSerial(Year(Date()),Month(Date())-1,1) And DateSerial(Year(Date()),Month(Date()),0) on the criteria .... not sure if its the best way to do it but hey it works

ok, you were all amazing helping last time so hopefully it will happen again. I have a report that shows all of the orders that happened last month. I want a label/text box/something to say orders for _____ and the month to automatically appear .... how do i do it please? huge amount of...

IT WORKED!!!!!! i love you!!!!!!!!!

s = rst.[OrderNumber Prefix] is the bit that is highlighted blue when the whole thing falls appart so im guessing that is the error line. will try removing record set now. i didnt do the original code or the original database so i will be honest i dont have a clue what half of it is...