Search results

I am busy updating a database and need to force the user to update information IF some data in a subform is incomplete, before being allowed to move to the next record. Bear in mind that the record is not dirty unless the user changes something. So I cant fire a Before/After update event. I...

Hi All Just a thanks to all who took the time to read my long post and submit your ideas. I think that I have found a completely different solution. For those who are interested . . . this is the solution. 1. On the Enrolment screen (which contains the 3 sub forms) the user clicks button to add...

OK - Could you use a summary query/table instead of a crosstab? So to paraphrase . . . Select sum(weight) as MyWeight, Client, Destination from Mytable where ShipDate = whateverDate group by ShipDate, Client, Destination

Hi All I think that Gasman might be onto something here - I will need to investigate the practicalities of that. For the sake of clarity (I hope that is what I might achieve) . . . The_Doc_Man - You are 100% correct. This is in fact what I want to enforce. So when a student is enrolled, he/...

Sorry - I guess that I should have mentioned that there is a lot more going on under the hood. In essence, the user clicks separate buttons to open (and thus add) seperate windows for Student, Family and Address. (This is because there is compulsory data that must be captured for each and there...

What if you created a hidden field on the parent and assign value 2 to that. The subreport could then be filtered on the parent field?

I see that you are using the suffix 'D' to identify something (I presume the carrier). Instead of creating a xtab can you not access a standard table and then Select * from tableName where WeightValue = WeightField and CarrierCode = CarrierField?

Sorry for the long post I have a complex 'New student enrolment' form that contains 3 subforms on it. I need to ensure that THREE conditions are met before the user is allowed to save the record. Access 2016 front end and SQL 2016 back end. The Parent form is the 'Enrolment Enquiry' form. The...

Solved it - I was trying to evaluate text against an integer field. DUH!

I have a student attendance form which opens showing all students who are currently enrolled. On the form there are 3 filters for Form_Filt (for the class name), Filt_Yr and Filt_AttCode. For Example, I might want to update attendance for Class "MS78A" (Which is made up of students from 2 year...

Yeah - that's the strange thing. When the query runs, it is inserting numeric values into the table - but if I simply run the query as a SELECT, then I see the 'garbage'. As for M$ error message - I couldn't agree more. My problem MUST have something to do with the data type by virtue that it...

In my solution, we plan and manage travel arrangements for remote students at the beginning and end of each term. (To get them to the boarding school and back home again.) To extract the list of potential students that will be traveling inward, I have a form containing 3 fields - Tvl_Year...

Hi Wag Do your record identify what type of question is being asked? (IE True/false, Multiple choice, your bespoke type etc) If so, my thinking is that you could do one of two things. 1. Create a separate form for each question/answer type. (Open/close) forms as required or 2. Show/hide fields...

Sir - You are an officer and a gentleman. I thank you

Good Thinking 007. . . I Have Many Such Tables (with The Scripts That Created Them) So Your Idea Might Just Work Wonders. I Shall Give It A Go.

Wow - that would be much appreciated. The same co-ords as the existing box would be fine. I am already having to relocate the fields anyhow.

Correct Steve - I'm linked to a SQL DB.

Unfortunately the 'right click' does not offer me the 'checkbox' option. (Checkbox, Toggle and Option buttons are all grayed out.) I first have to delete the textbox first and then insert a checkbox. Then bind the checkbox to the data. This is a pain in the proverbial!

NOTE: There is a difference between tabs on a NAVIGATION form and tabs on a TAB control.

I gather that you are new to Access, so this is probably the simplest way that I would do it. Create a form that links to your RFID/User table. Add a combo box to the form - when the wizard asks what you want to do with the combo box, select the option to find a record and follow the prompts...