Search results

Hi All, Hope you're well. I've been scratching my head with this one. Basically I am trying to create a table that will store the login credentials for the different cloud storage accounts (tblCloudStorages). The username for the Cloud Storage will be an email address but it could either be an...

Hi There, I am trying to create a query that shows the records that fall within the month of a specified date. For example if I selected the date 10th May 2017 in my date picker text box txtMonth how can I get the query to return any matching record with a date in May please. I have tried the...

Hi There, I am using the product inventory template available in access 2013 as a basis for my database and modifying it to suit my needs. I've successfully converted the tables, forms and queries into a local database from the web version. The only problem is during the conversion it doesn't...

Hi There, I'm looking for a way to display multiple records related to one ID in a sort of list view. I've seen that you can concatenate records into a layout like this: ID 1: Record Title1 - Record Data1, Record Title2 - Record Data2. But that isn't how I would like it displayed. Is it...

Hi There, I have a form that uses a combobox to filter by name to then show the relevant data in the two textboxes below. Now for some reason when I search for the name of the first record it shows the information fine but if I search for any other name it causes the entire form to go blank...

Hi There, I have a form which I use to add stock to the stock table. It uses the following code to do this: Private Sub btnAdd_Click() Dim iCtr As Integer 'Calculates how many entries to put into the table based on value in txtQty For iCtr = 1 To Me.txtQty 'Adds all fields into...

Hi There, I have a combo box that you select a name in and the text boxes below get populated with the relevant record. To achieve this I have got the following bit of code on the after update event of the combo box 'cboNameLookup': DoCmd.ApplyFilter "", "[StaffID] Like ""*"" &...

Hi There, I have a table that contains every single item of stock and they all have a unique ID. (Table contents can be shown in the attached screenshot). What I would like to do is make a Form Datasheet that shows a summary of all these items. I.e I have around 15 'K120' keyboards in my...

Hi There, I have a database that uses the table of another database for the names so I don't get a mis-mash of names across databases but for some reason when I try to do anything in the database that requires the linked table I get an error "'N:\Database.accdb' is not a valid path. Make sure...

Hi There, I am trying to generate a report where it shows me data up to a specified date. Currently I have a query that searches a table (tblBreakdown in this case) and produces a report with all data entry's that are equal or before the specified date. Now to the part I can't get working. I've...

Hi There, I am trying to create a query that returns all data with a date that falls within a month of the specified date I have entered. For example if I entered a date of 11/11/2016 I would like the query to return all records that have a date equal or between the 11/11/2016 and a month...

Hi There, I was wondering if it was possible whereby when you delete the selected text out of a combobox it returns the value of the combobox back to Null. To put it in context, I have a form with a combobox which when the form is first loaded the combobox is empty (Null). Now if I choose a...

Hi There, I have built myself a form where I can choose an office from a combobox and date range from a textbox and then run a query that generates a report to show all records that meet that criteria (see attachment for a screenshot of my query in design form). What I would like it to also do...

Hi There, I am trying to create a form where I have two comboboxes to filter through records and then show the record details in the textboxes below. The first combobox sorts type (in my case cloud storage type dropbox etc.) the second combobox will then only show the associated usernames to...

Hi There, I have a really simple form whereby you chose an option from a combobox and it populates the 3 textboxes below with the matching data in the table. Now every time I select an option from the combobox it renames the field of data in the table with a number. By the looks if it, it is...

Hi There, I have a combobox that has three columns, one of which is hidden as this contains the primary key. The other two are both visible when you drop down the combobox list which are 'dept code' and 'office'. However when I select an option and the list retracts it only shows one of the...

Hi All, I am trying to implement error trapping to prevent errors or incorrect data from being entered. The way I have it setup currently is a lot of 'If' statements for individual comboboxes to check if the combobox is a 'Null' value and if so to show an error message "Please select a value"...

Hi there, I was wondering what would be the best way of updating only a specific row in a table with new data from a form combobox? Currently I have a query that updates the OfficeID and MailboxID in tblBreakdown to what ever has been selected in the corresponding comboboxes on...

Hi There, I am trying to create a very simple append query that takes the primary ID's from each table (tblName, tblOffices and tblMailbox) and adds them to the tblBreakdown dependent on the selected data in the three comboboxes (cboName, cboOffice and cboMailbox) on frmMailboxAssignment. What...

Hi there, I am trying to get a subform to be hidden when the value of a textbox (txtAllocationID) is empty but when a ID number appears I would like it to become visible again. This is what I have tried so far but doesn't seem to work: Private Sub txtAllocationID_AfterUpdate() If...