Search results

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

Oh my, I have checked it and it does have multiple names for one person. How do I make it only appear once in the subform? I mean the name should only came out according to lngMessauftragNr. If you see in the photo, the field lngMessauftragNr is different.

Okay I just found out that my Backend does not contain only tables, but also forms and queries. Actually it is a normal form that contains everything, it's just the tables are linked to the frontend. That is why when I did some changes on the layout of the frontend, the layout of the backend...

Thank you for the reply. Okay but what should I be looking for at the query?

I have founfd the arrangement for the SQL. FROM (tblMessanlage LEFT JOIN qryMessauftragPerson ON tblMessanlage.ID = qryMessauftragPerson.ID) RIGHT JOIN (tblMessaufgaben RIGHT JOIN (tblFOLand INNER JOIN (tblPrioritaet RIGHT JOIN (tblPulk RIGHT JOIN ((tblBauphasen RIGHT JOIN...

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

Because on the other form that I was working on, I did not include the table tblBemusterungsstelle but it still works. I tried adding that table though, but it gets more complicated error. Feeling like smashing my computer already.

Thank you for your reply. moke123: I tried reversing the codes like you said but no improvement. The parameter window keep popping out. Orthodox Dave: Yeah I figured that is the problem too. I want to add the table which consist the "indBemusterungsstelle" but it won't let me run the query...

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

Yep. First I added the new table that I want in the Query Design. Then I save it, and changed to SQL-view, the code is already there. I don't know if I should rearrange the sequence of the sql manually or not. :(

Well I did. The sql (the first code above) is actually from query sql-view. I don't get why the person who write the code for the combobox did not follow the exact sequence from the query.

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

I have the same tables for both locations. Yeah I just did the copy and paste form from the navigation panel. But I don't know how to edit the source object or create a similar one. Can you explain a little bit? I don't quite understand.

I have been working to figure out one of my form for weeks. So I have this form that shows the task for the week for employees. But now I have two location sites, which means, I need to seperate the task according to location so that it won't get messed up between both location. Since the Form...

Seems like I can't edit the field in the query. Is there anyway to activate it? Yes, the field that I have problem with from both subforms are based on the same table. And no, it's not open at the same time. It's weird because the first form is editable but the second is not. I think the...

Okay but what should I be looking for at the record source query?

I have two forms, both have a subform on it and shares some identical fields in the subform. I am able to change the date in the field txtPruefbericht and txtDurchsprache on the subform of Form 1 using date-picker and self-type. But for Form 2, I can't change the date. It's unclickable as if it...

Thank you for your reply! So I need to add sqlWHERE in my VBA? And can you explain a little bit why it has to be related with the dates? I mean, I thought it has to do with a field on the location table.

I want to share you the file but the size exceed 2MB, even after I had simplified everything. So to make things clear for you, I copied the VBA codes in Note. So the form name is frmRunde and the calendar is a subform in loop. The thing that will differs between the two location is lngGruppe...