Search results

Ok i get the gist of it...but early and late binding....Intellisense...what is that......? Update: I did some google search on it and it seems early binding is faster....so how would i do it as early binding...

Thanks for the quick reply. Ok i have never used the CreateObject method before in VBA. Lets see if i understand you correctly. So i have to add the fields first in a "with" statement, can i then just use the addNew like this where etalsDisplayRecordSet is the empty recordset?: With...

Hi, Thx for the quick reply... Well that's what i have done...and it works nicely.....but...there is always a but As i have many users a problem occurs, when i refresh that particular form i delete the entries from the table and replace with new...so if i have many users online at the same...

Hi, All Im trying to dynamically create a ADODB recordset and then add records and then set it as the record source for a form.. What i dont understand is the open statement for the recordset. As i have nothing to open...? until i have added records to it...so what am i missing... thx Zozew

Hi all ive sorted it with this: With Forms!InmatesProfile.RecordsetClone .FindFirst "InmateID = " & Me!InmateID If Not .NoMatch Then Forms!InmatesProfile.Bookmark = .Bookmark End With

Hi, I tried this and it almost works....I have a mainForm with a recordset of profiles. In another form (CommonForm)on the MainForm I have a datasheet displaying profiles that have common data. What im trying to do is when i click on the records in the CommonForm i would like the currentRecord...

Hi, Im wondering the basic structure on how to open a record from a main table when i do a search in a related table. Setup: I have two tables main and cases The main table is displayed in the mainForm and the cases table is related by a mainID How would i do a search in the cases table and...

Hi, I have a db using some word files and writing some files back to the local drive...when i was using a default db (front and back together in one file) and from my dev folder all works fine with using word files for merger and writing to the local drive. But then I spleit the db to front and...

Hi thanks for the reply...im not sure how i would do that...with my query... The complete query looks like this.. SELECT DISTINCT tblBranches.Branch, tblBranchEscorts.Branch, tblInmateCases.CaseNo, tblInmatesProfile.InmateID, tblInmatesProfile.LastName, tblInmatesProfile.FirstName...

Hi again, I have a post in Queries about this issue but seen as you wrote the SQL for this i thought I'd ask you. The SQL for my report looks like this: SELECT tblBranches.Branch,tblInmateCases.CaseNo, tblBranchEscorts.Branch, tblInmatesProfile.InmateID, tblInmatesProfile.LastName...

Ok great thanks ill try to see if i can make it work. I presume the ORDER BY(in red) in the example should be the field i want to be unique? I want my Branch & InmateID per record to be unique the rest of the fields don't matter Copied from your link: SELECT Orders.CustomerID...

HI thanks for the suggestion, I have managed to come close to my goal by just using SELECT DISTINCT then i get the Unique values. Problem there though is that If you have other fields in your table that are unique for each row like i have a CaseNo field, you get the duplicates again...so i...

haha! It works like a charm...Thanks a million im starting to understand how you relate tables now in SQL queries. Thx again

I have another post about another query question but same db...this is another Question :o Base: 3 tables linked like this: Data Table 1 (tblInmatesProfile): InmateID, Name, etc Data Table 2 (tblInmateCases): CaseID, InmateID, Branch, Crime, Etc Data Table 3 (tblInmateHearings) CaseID...

Base: 3 tables linked like this: Data Table 1 (tblInmatesProfile): InmateID, Name, etc Data Table 2 (tblInmateCases): CaseID, InmateID, Branch, Crime, Etc Data Table 3 (tblInmateHearings) CaseID, HearingID, Hearings I have a query that returns a recordset for a specific date (Hearings)...

Hi again let me re-explain my problem better.... BASE: first table (tblInmatesProfile) is a person table with names adress etc. Second table is a table with cases (tblInmateCases) with caseNo, Branch, crime etc. that can hold Multiple cases for each person (linked by InmateID from the first...

ok I get that you can use "AND" for more criteria, but is there a way of specifying a UNIQUE value for a field? or to specify that i only want one instance of (InmateID) value if there are more then one...

Hi All, I have a problem i can't solve with this SQL string (below). What it does is a recordset of people (Names and some other info) based on a date . My problem is that on a specific date there can be multiple values of the same person (InmateID in tblIbmateHearings) and in my result i only...

Yep i got it :)

Well no actually, i have two subforms on the main form and i thought that would mess up any debugging. But maybe that's what you meant? Im not really familiar with how access compiles and debugs so ill test it just as you said. Although the problem is gone now id like to know why it happened so...