Search results

He can't change but only add new records (the problem is I don't want the hanges be saved in the table template). If you mean to set the table where i want to save it, then I won't be able to show my template records. TblOrderItems can't be joined to Items - there's no relationship between...

Yes to all the mentioned tables above, the problem here is that if the user wants to select an unassigned item, the item will be registered in table TblItems not? That's what I'm trying to prevent. I want to have a subform where the items from TblItems are shown and when the user wants to add a...

This is just an example. The purpose of this is that the user can select a template they want, where everything is already filled out (including the items). Each month the user prints the same thing with all the items (including more than 100items - that's why the use of a template - so the...

I've created a simple test version - in the main form i choose from combo box Name and after choosing some fields are automatically added from template tables (Items_template and List_Template). When I pick the first template : template1 - there are two items in the subform below (8,9) and i...

The form shows different data (template records) depending on previous selection (e.g. you can pick from more then one template)

Hello, so I'm trying to find a way to show data records from one table in my form List, but when the user changes something (e.g. adds or deletes a record) in that form, the changes (records) would be made in a different table and the first table would be without changes. Data in first table...

Thats's already been set like that. Section height as in header section? Where can I find these proportions. Can't share the databse.

Hello, I have this problem in screenview when viewing my report. Sometimes when I scroll down and then scroll back up, the report header suddenly disappears or gets stuck in the middle (like just upper half of the report header is missing). THe report is showing lines with IDs from a query and...

It looks like it's working. Doesn't switch anymore. Thank you

Do I leave the Me.Requery on the On Timer Event? Will it requery if I only set the timerinterval on the Activate Event and leave out the On Timer Event?

Hello, I have this problem with my report, that opens a form when i choose a line. The form is later opened but at some point (randomly) it switches back to my report. The report has a time interval set and also a procedure event on timer. The procedure just has a me.requery in it. Can it be...

This helped! Only it deletes the record in the subform only and not also from the form_class. How can I delete it from both forms at one time, because it deletes only the class record and the student is still there, when i open the record again and delete it, it's deleted. But I want to delete...

CurrentDb.Execute , dbSeeChanges _ I don't know if I understood correctly, I've tried this but it's not working.

Hello, I have a form (form_student) with student's information where I want to create a button with "on click" event and it should delete the record of this student from my table (that's called tb_student). Snippet of my code If MsgBox("Delete this student?", vbYesNo + vbCritical +...

I've thought about it, but I forgot to mention, that I would like to manipulate with the data later on, e.g. copy the data to a file or filter it however i want later on in the query. I've created a button in my form with that I can export the data in excel file, but I would like to know if...

Hi, so I have this form, where I can choose from the option buttons and input date in textfields after that I click on the button "Show data" and it opens a query based on the filter I made on my form. Except after I get the data I can't go back to the previous form in the accde version...

No theres no code for the query, just the one i posted with outputto, the formatting was there already. I don't even know where it came from, when i export it to excel, the first header line is in gray and bordered and bold. There is no code to it.

around 2000 give or take, the copy from query alone made the database freeze and not respond, could this much record slow the performance of the database ?

Well there's no window that just pops up and tells me to restore, but when the database is not responding I try to close the database and THEN theres's a window for access is not responding (sometimes theres also another row Restart) Yes I've also tried compact and repair, that didnt help. My...

Ah yes thank you i see it now, is there a possibility for the excel to open automatically when its exported? I will bear this in mind if can't find any other solutions will use the transferspreasheet.