Search results

Hi Everybody, I have this great little sheet doing some calculations with VBA and excel formulas. All is well until I decided to convert the resulting days into yers months and days.. =DATEDIF(0,3675,"y") & " years, " & DATEDIF(0,3675,"ym")&" months, " & DATEDIF(0,3675,"md")&" days" And the...

Hi Guys, Ive done a lot of searching and not quite got the answer im looking for... Ive got a form with a combobox thats empty (to start with) bound to a query. then i have a button on the form opening a small form for adding an item in the combobox. All works fine apart from something...

I have a field (squad) in a report that i want to group on and show a total for each group..the squad value is an integer from 1 to about 100 Now to the mess...i want to group the field on three values or rather three groups of values.. squad = 2 squad = 3 squad = all but 2 and 3 its the last...

Hi all, I've come to the point where Im looking at user levels and security for my DB and I've spent countless hours testing and finding the best way. I've read many posts condemning MS for removing the ULS in 2007 and up and others praising it.. I've also tried several examples from users...

hi a quicky Question regarding grouping and counting... Im counting inmates per Squad in tblInmateProfile in the query below. As well as a few other fields but i cant get the records to group and count properly. just counting the Totals per squad is easy but then counting the "Sub" counts is...

hi ya'll, im working away on my db and its going quite ok, spent the day trying to sort my popup problem. I have a popup based on a related table to the main forms table. opening the popup and changing some values from the popup table in the popup then clicking on a button to update a few...

Hi Is there any guide on how to split a table that has information relating to multiple tables (related)... Example Imported table: name, position, salary Existing structure of DB tblEmployee: name tblSalary: salary tblPosition: Position they are related through an autonumber key ...thats...

Hi Guys, The Query below finds the most recent record in a table according to a date field, my problem is i don't know how to integrate this Query into the Query below this Query to replace the "Last" function SELECT a.inmateID, a.classificationID, b.max_date FROM ( SELECT...

I have a Form with a Query record source and all is fine :) adding an attachment field to the Query and then opening the form works fine but running a filter on the form i get. "search key was not found in any records" I've debugged it down to: I have two of my fields in the Query with a...

Hi ya'll I got a query (from different tables) where I use the "last" option on a field (info) to get the last record in that table.. I guess it's based on the Autokey or just the last record in the table.. And that works great in my query mostly... It's just that it's not always the last...

Hi guys, Ive been on the VBA thread, DB structure thread and gotten invaluable help...now that im closer to actually restarting my development i need some guidance in how to best use Access forms and what they can do. I come from a Flash developer background and i could basically do as i...

Hi, I've built a db for a jail institution and im a little stuck in one area. Ill just give you a short intro first to the structure... db consists of inmate records, name, prision number, security class and squad name (plus a lot more not relevant for this flow) Example: inmateName: John...

Hi Ya'll Quick query question, i need to count each group (Squad) total, I have tree tables: tblInmates: inmateID, inmateNames, inmateSquad, inmateClass there are about 7000 inmateNames tblClass: classID, className there are 4 classNames tblSquads: squadID, classID, squadName there are...

hi guys, im revamping (redoing) a prisonInmate DB and i need guidance in creating the VBA for it. Data structure: The DB has inmates in 6 security classes (MinA, MinB, Med, Max, Rdc, Jasc) then they are divided into squads (A, B, C, P1, P2 etc) that mostly fall under one of the security...

Explenaition: Im adding a feature where the user can add records in a new table (people2) that will be related to existing records in a table (people1). Basically im adding a feature with visitors to a db with inmates in a jail. The visitors can visit multiple inmates and the inmates can have...

I have some comboboxes populated by the Value List option. When i set the "Limit to list" It still allows the user to input a value not in the Value list....? I use the same method for Comboboxes populated by a Query in that case the user gets the prompt "Not in the List" if they try to input a...

Hi All, Im setting the Visible property of a textbox depending on a value in a record (Archived = True or False) The Problem is that when i browse through the records it doesn't update the controls visability...or let me rather say it doesn't update. If i move any other window above the Access...

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, 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...