Search results

Hi all, I would like to have 3 buttons on a form. When clicking Button1, Button2 and Button3 should be shown and Button1 hidden. When clicking Button3, Button2 and Button3 should be hidden and Button1 shown. How can I do this when it is not possible to manage the object being clicked...

Hi all, I am having troubles getting a filter working. I have previously had succes setting a filter on a subform from a mainform using the following code: Me!subMaskiner.Form.Filter = "[Kundenavn] = [Forms]![frmListeMaskiner]![cboCurrentCostumer]" Now I have to filter a mainform but I...

Hi All, I am trying to make a column in a tabled form ascending when a certain checkbox is checked. Is this possible to do in VBA? Thanks -Ronnie.

Hi, Am I able to make sure that a value can be applied to only one record? If so how then? Thanks -Ronnie

Hi, I am making a DB which contains info of some components in machines I have. For instance I have info about the IP adress for the component. The info is filtered on machine and component but I would also like to display only the 3 newest updates for the component. The ID will not be...

Hi, I am having some trouble getting my report work correctly. I have a report, repKomp, based on some sub-reports which are based on queries. I have two criterias for the queries - the same two for all - saying that two FK's must be filtered on a variable, Mask and Komp respectively. I...

Hi I have a form with a subform on which I have some random records not necessarily successive. The number of records is incistant. What I would like to do, is to open these records in a new form. Anyone have an idea of how to do so? Is it at all possible? Also - I am still quet new to...

Hi I am trying to make a query that sorts my records by three cascading cbo's in my main form. At the moment the sub form containing the query is not updated before the third box is filled out. What I would like is the following: • When the cbo's are blank all records must be shown. • The...

Hi all, I am very new to Access and having trouble regarding some code in my DB. I am trying to open a certain record on a form when clicking a button. As I understand the help function I should be able to use the follosing code - at least that is what I have: Private Sub...

Hi all, First some explanation to my DB: I am listing different machines, frmListeMaskiner, for which I need to register info reg. different electrical components. Clicking a field in the machine column, "Maskine", will open a window with info about the components for the machine...

Hi, I am trying to make a db where I need to show a list in different states. I am trying to do this by inserting the list into a tabbed control. Then I would like to make the list refer to each tab and only show the posts matching the tabs. Is this possible to do without having many tables...

Hi all, I am trying to calculate the stock level for my spareparts. I am aware of that I am not to update the stock level in my table but calculate the total from the transactions. My problem is that I am a newbie and have no idea of where to write the code, what to write etc. :banghead: I...

Hi all, I am trying to make a search function for my DB. I am using agehoops' example db shown in the following thread: Search Function, of February 16th 2007 My problem is, that the table I am referring to in my search-query has some looked up fields. These fields are returning an...

My name is Ronnie Rasmussen and I live in Copenhagen, Denmark. I am working as a mechanical engineer. I am very new to Access and hope to get a hole lot wiser on this area. :)