Search results

In the 'Tools' menu, select 'startup...', then select your form from the drop down list called 'Display Form/Page' and make sure the 'display database window' box isn't checked works in access 2000 at least...

My problem is, I'm using a form to build up a query using VBA / SQL, and part of the WHERE portion of my SQL statement includes start / end dates. If I then enter dates in the UK format (dd/mm/yyyy), access will, on saving the query, reverse dd and mm if both are 12 or below. I've managed a...

Yep, think I had one of those 'moments of clarity' on my walk home from work. Seems realy stupid but I was under the impression lookup controls on forms had to have similar controls on the actual table (think it was an assumption I made early on and never got round to thinking about it...

Yep, think I had one of those 'moments of clarity' on my walk home from work. Seems realy stupid but I was under the impression lookup controls on forms had to have similar controls on the actual table (think it was an assumption I made early on and never got round to thinking about it...

I mean, I understand there are issues, but it is the easiest way for me to store a series of values that could be referenced from more than one table / form. If I use a value list I will have to alter every instance of it if I want to add a new value... There is no way typing values in every...

Yes, I know, but I know of no alternative that will work in the same way

So, basically my database has quite a number of lookup fields in tables as there is much repeated data, each one references to a seperate table with an autonumber field (ID) and a text field (Value) Currently I have column one (ID) as the bound column in such cases, as this is what the guy who...

For this kind of thing you'll probably need to use SQL embedded in VBA code. Sounds scary but it's not so bad to get the hang of, I found a very good tutorial here: http://www.fontstuff.com/access/acctut14.htm which basically walks you through something very similar to what it sounds like you...

This seems to do the job, copy into a Module in your excel spreadsheet (or if desired could be used as easily in Access once you have imported the data) Public Function SplitCityState(City_State As String, CityOrState As String) As String If CityOrState = "City" Then SplitCityState...

I would split them into seperate feilds in excel first, before importing, it should be reasonably straightforward to write a function in excel, something like: Mid([City_State], 1, (InStr([City_State], ",")-1)) should return anything before the comma Mid([City_State], (InStr([City_State]...

just one thought - how is the csv created? - if it was in excel you might have double quotes around the field with commas in it - if this is the case, you can open it up in excel and do a find / replace to replace the commas with something else (eg periods or nothing)

Well, I've got this working fine, and I'm also sending every record to a backup table with no primary key before I delete them (just in case). I was just wandering... as I have warnings switched off, is there an easy way to create a log of the records which could not be appended due to key...

Well, I've got this working fine, and I'm also sending every record to a backup table with no primary key before I delete them (just in case). I was just wandering... as I have warnings switched off, is there an easy way to create a log of the records which could not be appended due to key...

"FROM tblCoordinate" looks like you're missing a semicolon "FROM tblCoordinate;"

Thanks, I actually didn't realise that was possible (and now I feel stupid. Ah well). Cheers for the help

OK, usually I can figure these things out for myself, but I'm realy stuck on this one and any help would be appreciated background: I work in a small scale pilot production line, and we take a series of measurements for every part that we make, each of which has a unique ID. Sometimes we need...