Search results

Hello, I wanted to see who are using my split database in the company (a lot of user). I'm trying to understand about the Microsoft Jet User Roster. I found a thread about this here https://www.access-programmers.co.uk/forums/showthread.php?t=292292&highlight=jet+user+roster and downloaded the...

Is there any way to prevent the combobox/text from being grey in colour when it is deactivated? I want to disable the subform which consist of comboxes and textboxes from making any changes, thus setting the Active to No. But this will make everything shows in grey. If I just set the Lock to...

I have a table and I want to create a query with a criteria X-OR. My table looks like this: BillID CountryID TaskID Dates 10 1 3 01.01.2017 20 2 3 01.02.2017 30 2 4 01.03.2017 40 1...

I have a button on a form that should open a opup form when clicked. But the popup form is not visible. I can see something flicked on the screen when I clicked the button but the form is just not showing up. When I turn off the popup properties of that form, it works fine. This popup form...

I have searched about this and founs many familiar thread but it does not help with my forms. So I have a form named frmTeilebeschaffung and it has a subform which displays some records and a button which will open a new form named frmDatumGueltigkeit. What I want to do with my form is that...

I have 3 forms which displays the dates of the tests that we are doing. The dates of each following test must be on the same/later date as before. All dates are from the same table. For example, I have 5 Tests. Date of Test 1 Date of Test 2 must same or after Test 1 Date of Test 3 must same or...

I know this might sound simple but I am trying to enable the addition of new records through a subform on a form. Before this there is a * at the bottom of my subform to add new records. But since I added one query in my subform's record source, the * row disappear. I have tried setting the...

Hi, I have a form which looks like a weekly calendar (from Monday to Friday) and the Record is shown according to the date it was assigned. There is a function on that form where I can drag and drop the Record from one day to the other. The function works well with no error, but then I...

Hi, I want to create a query that will show the total number recordsthat have a specific methods. For example see photo. I have multiple number of Project with the same name but the methods are sometimes differs and sometimes the same. I know in the query I have to Group the Projects together...

My colleage got an Error message when starting the Databank. Error 3044: 'O:\...\AccessBE' isn't a Valid Path. Make Sure that the Path Name is Spelled Correctly and that you are Connected to the Server on which the File Resides. He said that he is working via Home-Office and during opening of...

Hi, does anybody know how do I insert a calendar date-picker at a parameter value input box? See picture. I have a query that will filter records between the given Start date and End date. Right now I have to manually type in the dates whenever I need to use the query but now I would like to...

Hi, how do I make coloured background for each record. See photo. The colour depends on the task assigned on the records. For example, when the task is set to Analysis, it will turn blue, when others, the background is normal. Does it have to do with the following codes? Private Sub...

I have a Form A where it displays the dates of the records based on Table A. Then I have a Pop-up Form where I enter some details of the record. There is a textbox where I can enter the date of the record. I am attempting to save the date entered from the Pop-up Form onto the Form A. The...

I have a Form with a Subform on it and the subform is showing records in Table Component. I just added a new field on the table, which will show the status colour of the component. The status of the component is taken from another table called Table Component Order. But for each component, there...

I have a subform that I want to filter using a combobox. The subform query is in the left side of the photo that I have attached and the result that supposed to show up on the subform when I clicked on the combobox is on the right side (in red box). The problem is I couldn't get the subform to...

I have a Form with a Subform on it and I want to build a combobox to filter the location. How do I combined two or more sub-location into one? For example I have two tables that arrange the location in General Location and into Measuring Location. Table General Location: LocationID /...

I have a form with a subform on it. Recently I added a new table in my subform query because it needs to update the record in one of this particular field when it is edited. For some records, when it is edited, no duplication occured. And some, when that particular field is edited, it...

Hi, I have been doing combox filter for a while now and it works fine except for this one Form named Messung. The form has a subform named sfmMessung and I would like to filter the records according to locations, thus, I invented the combobox for the location named cboStandort. Below is the...

I have a form with a subform in it. I recently just added a new table in the subform query. I'm having trouble rearranging the FORM sql into my combobox sql, because now there is a new line in my subform record source (in bold). FROM (tblMessanlage RIGHT JOIN (tblMessaufgaben RIGHT JOIN...

Does anyone know about the message below? You can not paste a form (or report) into itself. Choose a different form (or report) to use as a subform or subreport. I got it when I tried to open a form. It's not a Runtime Error, so it does not have a specific error number and it has an OK button...