Search results

In my database, I have a table I use to track the ins and outs of the inventory items. Fields are as follow : [N°](key), [Project], [#série], [ApprouvéPar], [SortiDate], [SortiPar], [RetourDate], [RetourPar] So, each record stores the item serial#, where it went, by whom, when it came back, if...

Hello, Simple problem: I have a form with 2 continous sub-forms. One used as a search form and the other to show related information. I use this code to filter the 2nd sub-form based on the 1st sub-form' selection. strRecord = "[N°] = " & Forms![frmGénNav]![subfrm1].Form![N°] 'msgbox strRecord...

Ah! That feeling, Private Sub DESCRIP_1_Click() Dim strRecord As String strRecord = "[N°] = " & Forms![frmGénNav]![frmInventaireNav].Form![N°] Forms!frmGénNav!sfInvCarFin.Form.Filter = strRecord Forms!frmGénNav!sfInvCarFin.Form.FilterOn = True End Sub Working like a charm.

Ok, here's where I'm at. I try to use the filter method likie this: Private Sub DESCRIP_1_Click() Dim strRecord As String strRecord = "[N°] = " & Forms![frmGénNav]![frmInventaireNav].Form![N°] 'msgbox strRecord Me.[reqInvCarFin sous-formulaire2].form.Filter = strRecord End Sub Now, I get the...

Yes, thanks. My two sub-forms are using the same querry so I assume that if I re-query, it will affect the results in both forms. Should I do a duplicate querry so each sub-form has it's own source? (I didn't even try to consider this option since there is the word "duplicate" in it) I have...

Solved - Continous sub-forms Hey, thanks for clicking this thread. I have a navigation form [frmInvNav] on which I inserted one sub-forms [Inventaire] in the Continous Form format. This sub-form takes it's data from a querry which assembles all the information from the MainInventory table. I...

On my report, in the page footer I have this: =Now() Which displays the current date when I print/display the report. I am french, but the good kind, from Québec... My access is in french too so the formula I have in my report's page footer is actually: =Maintenant() The problem is that...

That's an answer for a beginner like me! I know I learn the hard way but you made it clear in my mind now. I just had a hard time getting in my head that all my tracking info needs to be all mixted up in one table and queries and forms will get the data I need when I need. I know the...

I have one table for all clients. Clients are actualy devices that goes out in the field and back at the warehouse, in and out all the time. The 44 tables are for recording the "ins" and "out" of each individual devices. Each of the tables have fields like: OutBy, OutDate, ApprovedBy, InBy...

Actually, I have 44 "clients" displaying on my main form. I also have 44 tables, one for each clients that stores the tracking info for them. I then have one single form for entering client tracking info on which I only change the form's data source property to the table that I want to edit...

Thanks for reading this, I have a command button on a continuous form(form 1) and I need this button to open another form(form 2) when I press on it. So far so good. When I press the button, I need some VBA to open the form(form 2) , search for a particular table name based on the open...

Ok, thanks. That answer my question. My brand table is correct, I just put it the wrong way in my post. Anyway, I already read the normalization document, one year ago. Access get so confusing sometimes and I only use it periodically but when it works, it's awesome. I find that I can accomplish...

Thanks but I might have explained too fast, here's my structure: The table Brands contains those fields: Honda, Chevy, Kia and Porshe. And I have these tables: HondaModels: Civic, Accord, CRV, ChevyModels: Silverado, Cruze, Cobalt, KiaModels: Sorento, Forte, PorsheModels: 911, Cayenne, GT2RS...

I have a table named [Brand] and several tables named [Brand@@@Models], one for each field in the Brand table. I want each field from the [Brand] table to be related to it's specific Model table. I thought like that so I don't have a Brand#1 related to Brand#2 models, etc.. I didn't want to...

Hi, I'm fairly new to all of this, but I had to do something similar once. Have you read about cascading comboboxes in a form? It let you see only the choices that are relevent to the previous combo box selection, very useful and there's a lot of information about this on the web. Back then I...

Mmm, That's what I thought, I will have to select a date as default value, perhaps somewhere in the dark ages to avoid mistakes. I like Spikepl's idea to display something else in forms and reports though, that'll work for me. Thanks both of you. KB

Ok, and what about my index? Access still see each "Null" fields as unique. I still cannot use index to prevent duplicate entries because of that. Any advices? KB

Hi, To prevent duplicate records, I use multiple fields indexes, which worked fine until now. I learned that each "empty" fields are consider unique by Access, so not the best in an index to prevent duplicate records. I managed to have it worked using the default value property to give each...

Thanks JD, I red the article and that gives me something to work on, much appreciated! I'll post my results when I'll get some. KB

Hi comunity, I have this piece of code. I am looking for a way to INSERT INTO tblUniqLoc(SiteLoc), but for the records in tblUniqLoc(GeoLocID) that matches the user input in the same form's previous control: (" & Me.cboGeoLoc & ") Not on a new line as it does now. Private Sub...