Search results

Sorry for taking so long to reply Here is a view of my table relations My database stores information about documentation we have. Kind of like a library database. The main table is documents, it has 7 one to many relation and 4 many to many. 1 of those many to many field (township or Twp) I...

Thanks a lot it works fine For the error handling I'm guessing I have to adapt it to the codes I use?

Hi, I have search for documents form with 15 criterias. With that I build a where string in vba and apply it to a continuous form. It's source is a query. There are 2 criterias that each search text in a different ConcatRelated Field that I build because of a many-to-many relation. I think...

Any suggestions for a list of basic terms in vba? Website or place I haven't found on this forum or dictionnary in vba that I'm not aware of? Right now I'm looking how to say: "If (string) is a number then ... " And I'm sure I'm going to be looking for something else tomorow. I'm also...

Ok for the cascading updates. I don't see what you mean by duplicated fields. I know they are bad and I avoid them completely. Everything works fine. For the lookups in the tables do you mean the multi select combo boxes? I don't know if those are a good thing but there exactly what I need for...

Never mind I hadn't compressed it so here's the hole thing

Ok got it Here's the BE The FE is 185 MB... I'll take out as much as I can

Yes everyone on the server is read/write/delete to the folder My file is way too big even with all the data gone... actually it didn't go down when I took all the records out. I'm at 10,6 MO Your tool to reset the database didn't work. I think the browse's default location isn't avaiable on my...

I've rechecked all my forms and even my queries and all the lock properties are off. That goes for the one in the access options too. However the "Open databases by using record-level locking " box isn't on. Does that change anything in my situation? Edit: No it's still not working. Could it...

Thanks a lot for your reply I know for sure that my BE is accessible to everyone on the server and that my FE is properly linked. I'm guessing the problem is a property option that I'm missing somehow. Just for specification, I open the FE (on a different computer with a different copy) but as I...

Hi I've split my database to have 2-3 users access it at the same time over a network. The properties of the FE & BE are on shared but when I want to open a second copy of the FE it says that my BE is currently being used by another. All locks are set to none. Using Access 2007. The one...

The format isn't regular which causes most the problems. Source of the problem : All townships aren't the same size. The maps have townships they cover and sometime it only covers part of a township. The township is grided. The grid have Ranges(roman numbers) and Lots(decimal numbers). For the...

Hi, I want to search in a interval of roman numbers. I have 2 fields (RangeStart and RangeEnd). They represent lines of a grid on maps. Unfortunately I have occasional letters in my data, so they have to be text fields. I don't have any formatin for my roman numbers(the're entered like...

I"m looking for something really simillar but with numbers instead of dates, can it be done? I have maps that are divided in ranges and lots (Like a grid). I have 2 lot field (number fields), one is the begining of the interval and the other is the end (because maps cover more than one lot). I...

That part I get perfectly, but how do I apply it to my 2 Lot fields (1st and last lot) ???

Hi I've been searching a lot on the web for this problem, but I think it's rather uncommon... I'm fairly new to access and programing in general, but I'm a quick learner. I have have a multi criteria search form in which I filter maps. I use a VBA code to create my search string and then apply...