Search results

Looks good SrPuma. Excuse me for asking but could you just quickly tell me what the outcome of the function is, just so I understand it better? Ash

Please guys I am begging for some help here ..... as I have no idea where to start. Basically, I have a list of tests each test is an individual record and within the record there are fields such as test name and test directory (which, using hyperlinks, is used to find the actual test files...

No I understand that, but what I am getting is unusual it goes 1f 1b 1c 1d 1e 1a Then 2d 2b 2c 2a But on section 4 it comes out correctly at 4a 4b 4c Strange?????????

Thanks Neil, Ok, I think I'm gonna stick to what I have at the moment as it gives me pretty much what I need, however I still don't understand why or how to get the "sections to fall into alphabetic order. Could this be to do with the complex crosstab query that is used for the report...

Thanks Pat. Ok, I have figured out how to implement the grouping using the sorting and grouping dialog. But there is still a few problems: 1 - I'm not sure what u mean by add grouping code to the table? 2 - The sections are divided up into e.g. 1a, 1b, 1c etc. and the sorting isn't taking into...

The file itself only contains text but has a company specific extension i.e. not .txt.

Hello all, I am trying to extract some data from a file so I can import it into a date field. The data lies on the third row of the file does anybody know how to grab it??? The data is as follows: Test: 1a Time: 14.02 pm Date: 3-Mar-08 Your comments will be greatly appreciated. Regards, Ashley

I've tried sub-reports and they take up too much space. Basically I want to split up the report into three sections after a certain 'Section' is returned in the report. So it'll look something like this: Section ...............No. of tests 1 .......................3 2 .......................8...

Hi, I have a report that shows all the records of a crosstab query. Basically I would like to split the report up into three section. My main field in the report is "Section" which runs from 1-6. In the report I would like to have Sections 1-3 seperate then section 4 on its own followed by...

Pretty please......

Please help!

Hi guys, I have a bit of a tricky one here and have no idea where to start. Basically, I have a list of tests each test is a record and within the record there are fields such as test name and test directory (which, using hyperlinks, is used to find the actual test files (PDF's in a...

Afternoon, Still climbing the steep learning curve that is Access and VB! Please could you help. I have a list box in one form (frm1) that displays information from a table (tbla), I also have another form (frm2) that has a combo box with the same information as tbla but can vary from record...

Hi guys, I hope this is fairly simple to do. Have looked around but cannot find the answer. I have a form which is opened from the switchboard either in add mode or edit mode as defined by the switchboard manager. Basically, if the form is opened in add mode (or a record is added in edit mode)...

Thanks for all your help Chergh. Do you also know how to combat this problem the other way (point 2.)? For example there is a text file that exists in that directory which on the 3rd line says: Date: 3-Mar-08 How can I grab this? Regards, Ashley

Sorry that was me being lazy, I should have figured that out myself, thanks. Is there also a way to limit the DateLastModified to only show the date and not the date and time?? Thanks again.

Re: Looks good Chergh, only how would I get that to my field in the form??? Cheers.

Hi guys, I am fairly new to coding so please tell me if this is fairly simple. I have a date field in a form which is basically telling me the date stamp of a file. At present I am entering this date manually which seems long winded. Therefore, I would like to have this field automated and can...

Hi, I am new to creating charts and haven't a clue where to start. I have tried a few things but can not get it to work. I have a table that has a number of records representing a test. Each test has a field called section so that each test falls into a specific section eg. section 1. They...

Thanks DCrake, looks increadibly awesome, but as a novice I have little idea of wot's going on. Could you give me an idea of where I might be naming my folders please? And how I could incorporate it into an 'on Click' Event.