Search results

Hi all, I'm wondering if I am able to create a query which houses all of the counts for a certain topic. For example, I have assets which are broken down into types: Asset Count - Count of all the assets within the table. Desktop Count - Count of only the desktop assets within the table...

Hi all, Hopefully this is where this goes as it might not fit into a single chat area. In my current database, I have a notes field which is a Long Text in a contact table. However, this is what I would consider a dumb method in that it does not state who created the note, date and time and...

Hi All, I'm trying to replicate the Contact Details Form which is found in the Asset Database template. Within the Asset portion of the form, their subform has a total bar: I'm trying to replicate this within my asset database, I cannot find how this was achieved at all. my properties match...

Hi All, Bit of a weird one. I'm trying to make a "Go To Record" Combo box. I'm using the Asset Database template as reference and in their Contact Details form, it has the same thing (which works if using macro's). However, when I convert it to VBA and copy the code, I get the following error...

Hi All, I'm trying to open a Report in which it'll take the ID of the previous "Contact Details" form. This is what I currently have: Private Sub CmdNewStarterReport_Click() DoCmd.OpenReport "ReportNewStarter", acViewPreview, , "ID='" & Me.ID & "'" End Sub However, when I tap the...

Hi all, I'm getting a rather bizarre error when I tap the Refresh (set to All) button on the top ribbon. This is what it says: One error which states: The record source 'SELECT -1 as [ID], '(Manage Filters)' as [Filter Name] FROM Filters UNION SELECT "0" as [ID], "(Clear Filter)" as [Filter...

Hi All, I have a check box labelled "Show Retired" which when ticked, I want it to show assets labelled "Retired" and when it's unchecked, to hide them. I cannot quite figure out how this is done however. This is what I've done so far: Private Sub chkShowRetired_Click() If...

Hi All, In other languages, it's easier and better to be able to use named identifiers instead of their ID's, for example, in Java, you have an Enum: public enum AssetType { Desktop = 0, Laptop = 1, MobilePhone = 2, ... }; How would I achieve this with a Lookup table within...

Hi All, I'm trying to add new entries into my table but I cannot add more than two and then access throws the following error: Run-time error '3022': The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or...