Search results for query: *

Ok Here's what to do this seemed to work for me. The text box which is to contain the date set that formatted to the type of date you want, eg. short date. Then on the form load procedure use the Now command instead of Date. This seemed to work for me. So it should look something like Private...

In your table check that the corresponding field is formated to a date. If this is ok. Check that the table and form are bound properly, ie. the text boxes are all bound to the form, spelt right etc. Try these, if all this is ok, get back to me. LB

If some one could help that would be great. I'm opening a diologue box, in order to save a file in a specific folder. I think thi is sopme common dialog control. Any way I got the following code from a previous thread, along with a bit more which I stuck some where else. Any way, it works...

Right then, I've figured it out. Dan, your bit of code gave me an idea. I used this bit of code in a module where Path is called in so that Path = CurrentDB.Name . Function FindCurrentFolder(Path As String) Dim TknNumb As Integer Dim StrLen As Integer Dim PathLength As Integer Dim...

Sorry, but that still didn't work, I don't think that was the problem as I work with DAO, and it didn't reckonise CurrentProject.FullName at all. No, it's something with the Mid function, no idea what mind you. It wants an array. Your code has given me some ideas though. By the way thanks for...

Hi there dan and im, Yeah I thought im's suggestion worked, however when I implemented it properly in my working programme, it just returned the Network drive I was working in (J:\). I have a problem though, I pasted dan's code above and tried that, but it gave me a compile error and said it...

Cheers im, I knew it couldn't be that hard, I think I'm just having a thick day.

I have looked for this every where can't seem to be able to find it. I want to get the path name of the current directory that the database is open in. So for example say the file is open in some directory C:\Quotes\stuff , I want to be able to return this as a string. I know it must be...

Juddy, thank you for your advice. Unfortunately, my report is already bound to a table, and here is where it gets confusing, because it is bound to a different table than the report it is opened from is. If you understand my meaning. Therefore the record scource for the report already has...

Not 100% sure I understand your problem, but have you tried Select Distinct in your query instead of Select. This would eliminate the same number being displayed twice.

Iam tyrying to do the exact same thing, but haven't worked out how to output only the one report that I have selected in my from. Could you shed any light on this for me. Cheers