Search results

My table has a field that is a number (long integer) and I am trying to update the field from a form. On the form I have my text box set as Format:General Number. What I am missing here because I get an error message 3464 Data Mismatch? What should have the form control set to to clear this...

Great info here! Thanks all - I am sure based on the replies that I can do what I need

So if I understand you correctly have the table as a number but for the field on the form allow the user to enter hours:minutes and have code to convert it to minutes for entry in the table. That sounds good to me

The info is coming from an internal company form - I already discussed this method with the user and it is not practical for use in this situation. The time keeping is done at the class level and the teachers are not the one's entering the info. This method makes sense for the way the company...

Wasn't really considering text ... it is just one of the available options and I did see a post somewhere that thought this was a good idea. Again appreciate the input

Wow that was quick - thank you. I am thinking that I would, rather than an input mask, set the perimeters (sorry if that is the wrong word) for the field on the form - and limit it there to how I need it to appear.

I am setting up a table to keep track of the time it takes to complete a training course. One of the fields needs to be the time it took to complete the course in minutes. What is suggested as the best field type for this? Number, text....? The field will be used in the future to produce...

Thank you all that helped - I got this working!

Gasman - thanks - as I have explained in previous posts it has been a long time since I worked with access - it is only slowly coming back. Thanks all for your help

DUH - Thanks for you help - I needed refresh not requery.

Meanwhile, MajP the field is text but when I change dim ID as long to text I get "User defined type not defined"

I tried requery but could not make it work I would rather not close the form but how do I force a requery - or is there another...?

I have a form with a subform. A change on the main form requires a field on the subform be updated. I am using this to close and reopen the form which forces the update as needed but this opens the form to the first record. I need to reopen to the same record that I was one when closed. I...

Making headway - the following code seems to work. (this is the sql from the append query)!!! INSERT INTO [JD SOP TBL] ( [Job Description], [Required SOP] ) SELECT [JD SOP TBL].[Job Description] AS Expr1, [Forms]![SOP FRM]![Number].[value] AS Expr2 FROM [JD SOP TBL] GROUP BY [JD SOP TBL].[Job...

Ok so I am making some headway - I found I need to put the code on the afterupdate. I am sure this is what I need for both the append and the delete (if the mandatory is unchecked to remove the job descriptions/SOP from the JD SOP TBL) So please can someone point get me to where I can do the...

I know I need to do an append query that will update the JD SOP TBL to add all job description from the Job Description TBL as the Job Description field in that table and for each of these add the SOP number indicated on the main form. I started to create the append table but am stumped. I...

Why would I need a unique key - is that to avoid duplicates? If access automatically removed duplicates that is what I want

I will update and add the relationships tomorrow and upload. The JD SOP TBL is a many to many (hope that is correctly stated: There are many job descriptions and many SOP (Training courses). All job descriptions can require many SOPs and all SOPs can be required by any number of job...

I don't understand this at all - sorry but how would this work with out code to update the table with the necessary information? I think I have successfully uploaded the database as requested. I am really hopeful that someone can hep me with the code I need. I am getting totally confused. Thanks!