Search results

why didn't i think of that thank you dude... muchos gracias erm.. dankzegging heh heh

hi there had a search for this but kind find anything similar.. i have a calc field using a DateDiff function that gives the number of weeks between two dates - i don't want to use days - but i want to use part weeks - is there a way the function can give the number of weeks as a decimal...

don't worry... but i found a backup copy.... however i wouldn't mind knowing what could have happened so that it doesn't happen again. cheers

i have a form with a load of event procedures behind it - for some reason when i try to view the code it won't allow me. When I try to access the code through VBA the form is no longer on the Microsoft Access Class Objects list - yet the individual properties on the form still show that they...

thanks that makes much more sense cheers eggwater

ahhh sorry i wasn't concentrating i just cut and paste what you wrote dozy bastid that i am please forgive me this weekend i have mostly been completely wasted at a wedding...

i did that and it didn't work...

on Dirty i have solved it by using the On Dirty event - it's not ideal but it seems to be the only solution for my meagre programming skills. thanks how do you implement the [code] tags anyway?

no validation rule i don't have any validation rules - just the code that determines whether a record is meeting certain criteria...

still getting the same error message see attached image

Okay fellas and lasses please help me out if you can. I had this code below on the before update event of my form and it works like a dream - creating different flags for different levels of data... howver I want to add a new event that pprompts the user to dsave the record if the make any...

have started my queries keep ya posted... not started relatin' yet better get on it cheers

Hi I'm attempting to split a large flat table to make a relational database because it's gonna get accessed via the web using ASP eventually... and it needs to be slick with little redundant data etc etc... if iwas starting from scratch this wouldn't be so hard - but i gotta keep the data...

that looks the business thanks - will check ASAP I knew it was possible but there's never ny documentation on that sorta thing

hi does anyone know if it's possible to change an export file name automatically.... to fill you in with my export function this is the code I'm using: Private Sub Command90_click() 'export new records to SAP function Dim rs As New ADODB.Recordset Dim sql As String On Error GoTo...

i realise this but... when yr data is from a flat table that was made by someone else and the people using the old database are still using that data whilst you are working on a complete overhaul - it's difficult

I think I'll just ... explain to my users that if they choose 'none' it's a null and won't show up - it makes no difference to the export - I just don't want people to feel like they have to make a choice that actually appears on the form... the problem I have by changing the form source now...

null = "none" but my form's fed by a table not a query?! :confused:

hi comrades I want to have a value stored in a form yet expoprt as a null - I have a combo list - Deluxe, Standard, None - on the export the bound column exports a code letter (i.e. W, O, Null) - however on the form I want it to show up as 'none' - at the moment it looks like the field is...

thanks I solved my problem I think ... though if anything goes wrong I will reassess these answers cheers