Search results

If you have 2007 or later Access can convert it automatically, however the code that it produces does not always work, therefore you may have to modify it slightly

Solaris wasnt that bad, plus if your counting Linux in amongst UNIX OS's, then SuSe and Ubuntu I quite like!

use the form wizard or open a blank form and then select the table you want to add data to and set this as the record source, then just use the "add existing fields" feature, if you want to ask the user if they wish to save the data before comitting to the table you could use the some VBA to...

this may help http://www.access-programmers.co.uk/forums/showthread.php?t=64611

I was actually trying that same thing but with the object names rather then the cell refs in the excel form If me.txtRefDte.Value = me.txtSeen.Value etc etc doh!

you can either pre-format the spreadsheet to treat that column as general text, or you can prefix the data in access before you export it to excel with '

IM doing a simple data entry form for an excel sheet. I have 3 text boxes. txtID, txtRefDate and txtSeenDate and Im using the following code to add data in a new row Private Sub cmdAdd_Click() Dim iRow As Long Dim ws As Worksheet Set ws = Worksheets("RefData") 'find first empty row in database...

Good point Bob! :o

SAF will be a very hard act to follow, and Moyes is in for a tough time of it (goes without saying). A few bad results could see Moyes get the boot early on, but the reds should remember what SAF was like when he first arrived. Who will take over Everton now? Lennon seems to be favourite, had...

Im guessing your subform query is based on a link to the parent? create a report based on the subform query with the parameter passed to the report from the parent form?

if each row can have more than one code, then you should be splitting that part off into another table and creating a one to many relationship with your original being the "one" and the new table being the "many" think of an author who has written many books, the idea would be to have the...

you want to count using a crosstab then, not sure about your data structure though, sounds like you've got an un-normalized table.

You want to total text???? or do you mean you want to combine the text into a string?? for "concatenating" text see here http://www.techonthenet.com/access/functions/string/concat.php for summing/totally numeric data Expr: IIf(Isnull([CF1]),0,[CF1])+IIf(Isnull([CF2]),0,[CF2]) etc etc

Solved it, for anyone else with the same problem, check the DaysByMonth example here (sample db by khawar), just switch his form1 date fields with the fields from your query/table (start/end date) and bingo your done! :)

got to be the "chosen one" Is it def confirmed that SAF is stepping down then?

Hi folks been trying to get my head round this one for a while, and I seem to have hit a brick wall. Im looking to get the number of bed days (overnight stays) from my database. Ive used a query I found on here to get the number of nights based on a start date and end date. StDte and EndDte...

I suppose it depends on the format of the drive, both OS's need to read/write so you need a compatible file system. Windows will only read FAT32 or NTFS unless you use some 3rd party software (back in the day, we used SAMBA). Check the file system of your Mac Drive!

which is why I always have a software firewall on all my nodes, can make things a bit tricky at times but it does give a little extra security

If its not nailed down, then yes, some Scotsman has probably tried deep frying it :D

they are indeed, but I dont know about a delicacy right enough, more a dentists/cardiologists nightmare