Search results

I have a form which I can filter using a combo box. The form is based on a query whicht looks up the criteria for one field in the content of the combo box. This is what is what I use in criteria field to look up the combo box's value: [Forms]![NameOfFormWithComboBox]![ComboBoxName] The combo...

That is exactly what I am doing. I probably just explained it badly. After thinking about it, I guess I should rather link my field to the query rather than store the calulated value like I initially wanted to do it. (I completely forgot about 3NF) Thanks for pointing it out to me.

What I want insert is the time taken form for the task. The start time is set when the record is created and the end time is created when the status is set to finished. So I can only calculate the value after the status is changed. I walso want make it possible for the user to change the time...

I have a combo box in which you can choose the status of a task (not yet started, in progress, finished). When the status is set to "finished" I want to insert a value that I calculated using a query into another field of the form (I want to use the BeforeUpdate event for this). What I don't...

I am not reallly sure what you mean (or if my explanation above was any good). Below is a pic of my relationships (55kB) but it's in German. The tbl_Rechner_Allgemein is the PC table and the tbl_Software_Lizenzen is the License table.

I am making a hardware & software inventory database. I've got a many-to-many relationship between my PC table and my software table so I can keep track of which software is installed on which PC. I also have a one-to-many relationship between my software table and the license table (the license...

Thanks Rich! I found out what caused the runtime error: I thought that Me was referring to the form that currently had the focus and not the form that the code is on :rolleyes: Me.PCID.SetFocus was trying to set a focus to a field in the subform that was hidden :rolleyes: Now I only need to...

I just tried the following but it gives me the run-time error as well: Form_frmMain.Seite10.SetFocus Me.PCID.SetFocus I also tried using PCName instead of PCID (they are both unique on the same table/forms) and then it works if the focus in the tab that I want to switch to is already on...

PCID (PC ID) is an AutoNumber field. By using something like this: Forms(0).RegisterStr0.Value = 3 ? I tried this as well but it still gives me the same Run-time error. The problem is setting focus to the PCID field. I have no problem to get the focus to the right tab.

Thanks for the reply :) No, I am not on a new record. It goes to the record I was looking at when I last looked at that form (which is an already existing record with all the required fields entered).

All of my forms are subforms on different tabs of my main form. What I want to do is switch to another tab and open a corresponding record (they are related through a 1:n relationship where the 1-side is the tab I want to switch to). This is what I tried but it doesn't work: Private Sub...

I closed access and opened it again and now it works :rolleyes: It does show the date and the time though. Is it possible to make it only display the date? Thanks

I want to record the date when a record was modified. I did a search on the forums and found this thread. Now I did just as described and put this into the Before Event property of the form (DateChanged is the field that will hold the date): Private Sub Form_BeforeUpdate(Cancel As Integer)...

Thanks, it works now! The only thing I don't get is that when I use: Me.SoftwareID.SetFocus it gives me an error while when I use: Me.SoftwareIDfk.SetFocus it works although the field I want to focus on is the SoftwareID field (and not a foreign key (it's name is SoftwareID) :confused:

All of my forms are subforms on different tabs of my main form. What I want to do is switch to another tab and open a corresponding record (they are related through a 1:n relationship where the 1-side is the tab I want to switch to). This is what I tried but it doesn't work: Private Sub...

Thanks, now I need to get to the corresponding record as the "where" command of the DoCmd.OpenForm works only if I use DoCmd.OpenForm :( This is what I tried but it doesn't work: Private Sub SoftwareIDfk_DblClick(Cancel As Integer) Dim buffer As String Dim rst As Recordset buffer =...

I am making hardware & software inventory database. All my forms are subforms on different tabs of one main form. What I want to do is use an event procedure to switch to another tab (and thus form) and open up a record corresponding to the currently open record in the current form. I am...

Thanks (both of you), it's working! One more question though: All my forms (frmPC, frmSoftware etc.) are tabs in one main form. How do I need to modify Brad's code for it to switch to the tab of the software form instead of opening the form in a new window? PS: Is there any way to edit the...

I don't really know whether this belongs into forms, macros or VBA so I'll just post it here. :confused: I am making a hardware & software inventory database. I have got all the data on each PC stored in tblPC which is linked to the Software table in a many-to-many relationship. One of my forms...

I am working on a database to keep track of the hardware and the software inventory of the company I work for. The "main" table is the workplace table which basically only holds the WorkplaceID, WorkplaceName and RoomNumber. It is linked in a one-to-many relation hip to the PC table which holds...