Search results for query: *

Also had this problem. I compacted and repaired the DB and afterwards it was working fine

Access 2000 Runtime Environment Any ideas?

Why does my application work under Windows 2000 but not with Windows 98 under Runtime Access. Throughs 'Invalid Page fault Kernel 32' error. Thanks for any help.

Thanks Leigh: Works great. Had a couple of functions trying to do the same thing but getting compicated. Cheers

Hi: I am import a CSV file line by line. I store the whole line in a variable. Variable may look like: 56,HighStreet,London Is there a function that can split the variable to the commas e.g. can i 'grab' then 56, then the HighStreet then London? Any help appreciated

Hi: Can anyone help. Does anyone know how I can allow the user to browse and select a file. This file name then has to be stored in a variable. Any help appreciated.

OK think i understand what DoCmd.TransferText will do. Is it possible however to state what field I want the data seperated by the commas to be transfered into? e.g. The table that I am transfering the text file to has 32 fields. Only 13 of these fields will be given values from the text file?

Can anyone help: I want to read data from a csv file which will be used to create records within a table - called Jobs. The files can have various rows BUT each row always has 13 columns. Each column or data separated by a comma will be entered into a different field within the Job Table. One...

Dean: Cheers very much what a great help!!

Hi: I am redesigning the front end of an Access 2000 database. I wish to change the backgroud colour of all forms. Does anyone know how this can be done in code rather than manually going through each form?? Any help again greatly appreciated. Cheers

Hi: I am redesigning the front end of an access 2000 database. I am looking at changing the background colour of all forms. Does anyone know how this can be done in code to prevent myself from having to manually change the value on every form. Any help as always greatly appreciated. Cheers.

Can anyone help: I am trying to create a Holiday Schedule in Excel. Every month is on a different page. Each member of staff is colour coded. Cells will be colour coded to show who is on holiday when. I would like to have a field on each page to show the total number of holidays taken for...

Rencently unistalled AOL and now using the default Internet Explorer short cut - ISP is now OneTel (normal dial up). Every time go on to internet after 3 - 5 minutes get warning "Windows must now restart because the Remote Proceedure Call service terminated unexpectantly" Anybody...

Can anyone help: I am trying to create a Holiday Schedule in Excel. Every month is on a different page. Each member of staff is colour coded. Cells will be colour coded to show who is on holiday when. I would like to have a field on each page to show the total number of holidays taken for...

Excellent guys!! Yet again a simple thing - its better to ask sometimes than spend ages trying to work it out!. Cheers again

Hi, I have a field called which auto generates by a piece of code for every new record. The field in question is a text field and has a prefix of 'PTCL' and then the number e.g. PTCL123 becomes PTCL124 on a new record and so on. This works fine until the value becomes PTCL1000. Since it is...

Anyone help?? Im opening a report which contains a sub report. The main (parent) report always has data but occasionally the sub (Child) report does not. I would like the report not to open when the sub (child) report has no data in it. I know there is the 'On No Data' Sub but not sure...

Hope someone can help, Does anybody know of a way to prevent the user scrolling through a recorset on a form by using the 'wheelie' mouse. Any info greatly appreciated Cheers

Excellent Paul works good. Always is something simple n you try to make it harder than it is!!! Cheers for the help Drew

Hope someone can be of help, Does anyone know how to round ALL decimal numbers up to the nxt whole number e.g. 1.1 would be 2, 2.3 would be 3 and so on. Any feedback would be greatly appreciated. Cheers Drew.