Search results

Open the table in design view. I the field properties box for the field in question the decimal places property is set to "auto" by default. Cick in the box and a scroll arow appears. Open the scroll and pick the number of decimal places you want. Or Just highlight "auto" and replace it...

I would hate to recommend a book for this sort of subject. Problem is that there are many good books out there until you actually purchase one? Point being is that I have bought books like this in the past and they have always been great until you find that they don't answer a question that you...

Haven’t you figured it yet? Mile just don't like clocks. He’s probably one of these people that never wears a watch and is always smack on time for everything :D :cool: Awe go on give us a peek Must be really :cool: if it's totally original. May be even get an award at the Tate :D

Your welcome

Well theres lots of different ways you could do this through your GUI You could do it automatically by having the code look for a default when you open the db. If the default isn't there then an IF routine will link to the alternative. You could do it semi-automatic by placing one or more...

Forms are used for imputing or displaying data not for storing it. Tables are used for storing data. If you already have the information, you do not need to "cut" it from one form and "paste" it to another. You just need to refer the controls on your second form to the, already, stored data...

On rare occasions

No problem You can prob do it in code. If you placed a button group on your form you could place the code behind the buttons. Take a look at this thread Here I think this is the sort of thing you need to do.

Never found a good book on VBA but I use a combination of QUE using Visual Basic, this forum, the VBA help files (which are better than most MS help files), and I often, (especially to start with) created a macro, converted it to VBA and studdied the code. With your knowledge of SQL as well what...

You should be able to do this through the linked table manager

MY SQL is supposed to be about the best

MS access help ----- type create custom help in the search screen and it will tell you all about it and even tell you how to let your end users use the F1 key to access it

Hmmm sorry didn't realise you needed to do this in code. I don't know why your code is working on your machine and not on others. I have just tried this opp. on my machine and I found that it worked if the excel file was on my HD but not if I tried it pulling a file off my server. So there is...

If you use the import wizard in access it gives you the option to use first row of a spread sheet as col. headings.

Excuse my possible ignorance but why do you need a blank form for a non existent entity? :confused: In theory it should be possible by creating a form with the, necessary, unbound controls on it and creating an If loop (or a series of) in VBA. The exact syntax for this shouldn't be difficult...

Yes I have seen something similar before, but not on a Novell system and not with Access files it was with another db. Had a ssimilar instance on a Samba server under SuSe Linux 7 a couple of years ago. Something happened to the naming conventions and the whole server got screwed. We later...

I will help if I can but this sounds first and formost like an accounting problem rather than an Access one. Access can handle this sort of thing easily. But first you need to analyse the exact problem. In order for me to do this it will be necessary for me too understand more about the...

seems an awful long winded way! Why not just run a query to find all unpaid accounts older than say 30 days from date of issue? If you need to move these to a different table, (though I don't know why you would do that because if they then become paid you will need to move them again),use the...

I seem to remember seeing some posts here on auditing but don't know if they would apply to this or if any examples could be applied retrospectively. Must be worth a look though. As for stopping duplicates in the future how about this: Give each contract a unique account. Include a routine in...

Yep but don't tell my client's...... they pay us a lot of money to admire the traffic on the M25! :D