Recent content by JamieRhysEdwards

I really wish I could, however I've split my database and the linked tables are on a network drive... meaning it would not be usable in any way if I tried to mess with it

Sorry all, I've updated OP on how my table is kinda structured

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

THAT WAS IT! I changed it to ContactNote and then updated my code to reflect the new change and it's worked.... Don't make it easy sometimes do they? XD

I tried that and it looks to be correct (not that I'm a sql expert in any stretch of the imagination. This is what I get when I get when I remove the single quotes: CurrentDb.Execute "INSERT INTO TableContactNotes (ContactID, UserID, Note) Values(" & Me.ID.Value & ", " &...

I've decided to implement the table, however, I'm getting the following error: Run-time error '3134': Syntax error in INSERT INTO Statement. This is my statement: If (Me.TextNotes.Value <> "") Then CurrentDb.Execute "INSERT INTO TableContactNotes (ContactID, UserID, Note)...

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

Thank you @strive4peace, that was exactly what I was looking for! I didn't even bother looking at the ribbon at all!

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

@theDBguy - If I change that line of code to what you've said, it then just automatically defaults to the first entry of the ComboBox list (even though it displays the name I've chosen

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

Yeah... Knew this would happen. The reason it was asking for the ID is because I hadn't set the Record Set on the Report itself.

I know something is wrong XD however, I'm not sure how I would even be able to make a sample db with this problem is as it's likely going to work...

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

Thanks for the support all! I think I've figured it out (might not be the most efficient way of doing it and I'll soon see). This is how I'm doing it at present: Private Sub Form_Load() ... TempVars("AssetList_ShowRetired") = False ... End Sub Private Sub chkShowRetired_Click()...