Recent content by RichP

Just to help: dim IFN as integer iFN = FreeFile Open "C:\myfile.txt" For Input As #iFN will open myfile Then dim msLine as string Line Input #iFN, msLine will read a whole line into msLine Then finally you can use something like this to read each value out at a time where the delimiter is...

Whenever I've done this I've always done as namliam suggests Once you've done that you can link it to your table. edit: Given that you also want to do this: In that case I've written VBA to read in the whole file and import it into the table rather than just create a linked table so I can...

As noted by the others, my solution won't work well in a multiuser environment and you will need to use the RainLover stuff to make it work

Or for fun you could set the default value for RID on the form to =nz(dmax("RID","Table1","Left$([RID],6)=format(Date(),""YYMMDD"")")+1,format(Date(),"YYMMDD") & "01") where Table1 is the name of the table that contains RID. This takes the maximum value of RID each day stored in table1 and...

Closing the form is a bit difficult because you want the code to close the form to be part of the same command button that opens the excel file. You may therefore get into problems with things happening in the correct order. However try this in the on click code for the command button...

try Format(Date,"yy")

Will it still not work for you? You create the initial email that is sent out using Access and that is sent to each person through Outlook on your computer. The emails are just plain HTML and each person stores it in a 'drafts' folder or the such like. Then, when they want to send in a ToDo...

You're right, I can :o Here ya go - the query Query1 does what you want I think

i'm sorry i haven't made enough posts to upload a sample db. I also made a small mistake Anyway, assume you have two tables. Table1 contains the data ou want to calculate the rate for and has a field called 'days' containing the number of days RateTable contains three fields called FromDay...

You can use a 'BETWEEN' join between two tables to do this if you like. Then one table is a look up table of the rates e.g. from, to, rate 1, 6, 10.23 7, 13, 8.345 14, 100000, 4.22

That. You can then also set the Word doc to be a form so there are only certain fields where than can enter the data. It should then be easy to read back the forms If you wanted to upgrade to Access 2010 then you could use the collect by email feature...

I haven't done it myself but it is possible in Access 2007 and 2010 to collect data by email. The link for Access 2010 is here office.microsoft.com/en-us/access-help/add-the-data-collected-through-e-mails-to-your-access-database-HA010341539.aspx (sorry I'm not up to 10 posts to you'll need to...

I'm not completely sure what you are trying to do but it sounds as though you have a field called dat100 and you would like it to be red if the value is between -0.1 and 0.1. If that is correct then you need to set the conditional format to 'field value is' 'between' '-0.1 and 0.1' where each...

If you open the Excel file using your command button before opening the linked table from within Access then Access does indeed seem to open the link as read only which is what you need. However, if the point of having the button is so that people can click on the button if they have to fix...

I suspect that Paul is correct. You could check by trying to open the file from Excel itself without using the Access command button but with Access open so it also has the Excel file open. If you get the error then that is a good clue as to what is going on