Search results

I type too slowly!!!!!

when doing open with, select the "choose program" option and when the next box appears ensure you have the "always use this program......" tick box checked. Alternatively open windows explorer select the tools menu and then Folder options and then the file types tab. Assocuiate .mdb files with...

The MS approach is the one that i use. The reason for the error is that Access uses the format of the first line of data to determine the field type, hence controlling the content of the first line will set your fieldtypes correctly.

As stated you cannot store text in a date field. If you are only concerned with seeing "To Be Confirmed" on the form you could put a label next to the date field that displays TBC when the date is null (no need to store in db. Alternatively you could play around with laying a label over the...

Working in the property industry i would say you need to keep them seperate. You need to put the Property and Unit primary keys in the lease table and create a composite primary key. your table would look something like this Prop_ID Unit_ID Rental_Start_Date . . . The combination of Prop_id...

solution??? The easiest way i can think of is to create a button on your main form. This button will run an insert sql statement that loops the number of times in your numphotos field. I don't have access on this computer to test but i think the code would be similar to this. ' variable that...

vaguely remember using this in the past to solve a similar issue if me.dirty = true then msgbox ......... (me.dirty will return true if someone is editing the record) can't find that actual code but i think the function should help Hope thsi helps. Ant

The FE/BE question needs to be answered, it would also be useful to know if it accessed by multiple users.

When access imports data it sets the column type using the first rows data. In the past i have entered a dummy row of data with text in column A Row 1 and then subsequently deleted that record as part of the import. Alternatively you could try ordering your spreadsheet, prior to import, so...

if you have access and it will not open in design view, try holding down the shift button whilst openingthe file. This functionality has probably been disabled by the developer but you never know.

property database Working in the property industry i feel your pain. I'm not able to add much more but can emphasise the point to not go down the append route. If a property is sold or withdrawn you can copy the details to another table(s) but my experiance says that users will want to copy it...

Attached solution Hi, I have created a quick sample solution and have attached it as a zip file. It contains 1 table and 3 queries and hopefully will make more sense than me trying to explain it in words to you. Best of luck and let me know how you get on. Regard Ant

self join I'm not sure if i completely understand your problem but i think you might need to do a self join (use company table twice joining itself) on the table using company name as the joining field. Then extract all the common information from 1 table and the second member name from the...

Hi, I have tried many different things to get this to work but can't, i'm hoping someone on here can shead some light or just tell me it is not possible. I have a report giving detailed spend by particular individuals and then a sub report in the header that lists the total expenditure for...

hope this helps I have done this many time and follow this method.... It assumes that you have a primary (unique) reference to return the single record. 1) create a query on which to base the report that will return a unique record. e.g select * from table where table.unique_field = 1 2)...

Thanks that is great!! I think i was trying to over complicate things as usual. Cheers Ant

Hi I need to write a macro that will copy the 1st row of my spreadsheet and insert it into the row above the current users selection (which could eb anywhere). I can insert a row above the users current seelction using: Selection.EntireRow.Insert i then need to copy the 1st row into this row...

alternatively opening your databases ldb file in notepad will give you the machine names that are accessing the database.

Invalid headers Access tries to import a field as F1 when the headers you are importing are not valid. Check your headers to see if there are any 'dodgy' characters (.,/ \: etc). Alternatively it also uses F1 if you have not selected 'include header row on import' Hope this helps! Ant...

Spec: Access 2000 front and Back End, Jet sp8 I have a database that stores both English and Czech Characters. All characters display correctly in the table and on any reports i write. However, when i export using TransferText some of the characters accents are missing. I have discovered...