Search results

No worries i think i have sorted it by changing the default input mask generated by access. Thanks for your help, it seems to work without val() now, i believe it was something to do with the spaces at the end of the input mask. In fact, yes, Val(CompanyDiscount) does have to be used; in any...

Yea, i tried using val() previously but it just returns 0. I'm not sure why, Jon.

A field in one of my tables an input mask which means the user must enter a value into (__)%. Now when i run my invoice report i need the discount percentage to be taken from the total. For this i could use the code: GrandTotal = SubTotal - ((SubTotal/ 100) * (CompanyDiscount)) However, here...

Thanks a lot, i'll take your advice into account. I've favourited the website -i'm sure it will be a good help for future reference. Jon.

Well if he won't thank you i will. I'm just currently messing about with the whole hiding menus etc thing. Cheers, Jon.

Much thanks, i will look into this in the future! Jon.

Now the module works, i don't really know why it didn't in the first place but after this little problem i think my project is finished, good news, now to test it - oh dear! Thanks for your help, Jon.

ah i see and yes just to confirm, system.mdw has been recreated. Except it is now in C:\Documents and Settings\Jon\Application Data\Microsoft\Access instead of in the windows folder :confused: Makes no difference to me, it works! Jon.

Hmm, well unsuprisingly with the complexity of the other answers to this problem it doesn't work. When i first tried it i can honestly say it did, but now it doesn't ... I'm even more confused, thanks though access i'll take a look at that. Jon. Edit: it's really quite strange, it now...

I too had this same problem. I tried what linq said but it returned the same error and i'm not really sure how to work with modules so to (with some luck) fix it.. I created a new macro with the openform action. The properties were set as: Form Name = yourformname View = datasheet Data Mode =...

Ah what a relief, fantastic that's just what i was looking for. Just a little edit, took out the zip function and it's perfect. Can't thank you enough, +REP Jon.

This is my slightly altered version of the code: Dim bckup As FileSystemObject On Error GoTo Unsuccessful Dim strBckupName As String strBckupName = "BackupDB - " & Format(Date, "mm.dd.yyyy") & " - " & Format(Time, "hhmmss") & ".mdb" Set bckup = New FileSystemObject bckup.CopyFile...

apologies, i meant to say that i deleted system.mdw ! not system32 - oh dear. I won't mess with this stuff again, but dennisk can i ask why deleting system.mdw instead of replacing it with a fresh copy has worked for me?

Is there a way to use code similar to this in access, all i can find is FileCopy but i don't think that lets you save the database you have open and in any case it doesn't function like the savecopyas code. When i made a project excel i used the code below which might be useful to the original...

Ah i understand, the reason i wasn't sure before was because i needed to have a more thorough search for it. Strangely i couldn't find it on the new pc (perhaps because it is vista and new so the microsoft office (demo) '07 hasn't even been properly activated yet, but i think more likely because...

Whoa, scared myself then. Thank god it works on my other pc, ok now im not on my knees praying it will work, i was wondering if i simply reinstalled Access would it solve the problem? However, I'm guessing it's not that easy!

Ahhh! Please help, i don't what i did, i don't understand what you mean to rectifiy this problem but for all my databases i get the same problem explained here where logon is displayed. Maybe you can explain in simple terms how i can get rid of this? I don't understand what's happened Thanks, Jon.

Ah thanks bob i will use dcount myself to check for no records being located, seems like a good method. Is it possible to do something like this with two criteria for example i have: If DCount("OrderID", "tblCustomerLink", "CustomerID =" & CustomerID) = 0 Then GoTo NoSelection but i need it to...

Hi, - I had a form where orders are shown and a subform within it where products can be selected for these orders as desired - All the records were displayed in the form Now i added another subform where the orders can be assigned to certain customers. This form works fine and the values...

Thanks for your advice, i realise now that me.dirty does not do what i thought it would and so have used a query instead so that records which have allready been selected and not displayed in the drop down box. Thanks, Jon.