Search results for query: *

That is what I needed to know. Thanks PH. Just curious what is the difference between a long integer and an integer?

Thanks PHV, I still want to give my QC people the option of the current year IDNumber first (i.e. 2014-0009 if the last id for this current year was 0008), before a different year is asked for. Why the use of a long instead of an integer for nextId. What is the difference between the two data...

This problem was solved when I followed MajP suggestion to use unbound fields and modify the code MajP gave me for my form. On the AddNewEquip form I never wanted the user to see existing records. This form from the start was only to add new tools/equipment. I have also been working on two...

Two questions then. 1. How would you setup a combobox for year(date) so it could go back say 12 years so they could enter all the old paper records. Would I stll need a seperate year field for when they enter new stuff or just use the combobox if it can bring up the current year. 2.I thought...

Also adding to the second question, since this program will have zero records when I give it to the Quality Control people. The year field in the above idea would have to be changeable as they will have to enter manually all of their old data into this program. Currently all of their records...

To answer your first question. Yes this is a new form. I tried the command button wizard to save the change, but I did not like the fact that it did not reset the fields to "". So, I used code to do the docmd.runcommand.accmdsaverecord to accomplish the save change and then clear the fields...

Alright, I found two more typos. Fixed them and the code worked flawlessly. Now I have another question. On another form that updates data, it finds the record to be updated but I did not set up a way to save the change to the record. If I use the command button wizard to create a save...

MajP, I tried both ways today at work. First I tried the DataEntry Mode. No matter what I did with this code and attempt it kept modifying an existing record. Next I tried the coding for unbound fields. On the first attempt through I was getting a runtime error of 3134. I went back through...

Thanks MajP. I will try both ways out tomorrow at work.

TheAceMan1,,, I will check the Data Entry mode out. Klepdog

One field is a date field and is formatted as short date. The control field (called in the table as [LCLID]) is set as text, but I was wondering if I could set as number. The required input is four numbers then a dash followed by four more numbers. What do you suggest. The rest of the fields...

A simple 6 field form that only creates new records. The record source for this form is on form load "select LOCALMAN.* from LOCALMAN". Two command buttons, One to save the new record and one to close the form. No scroll bars or record navigation bar. This is a single form. One field is a...

How do you move to a new record, if the new record property shows false? I turned the navigation bar off to help prevent the user from modifing an existing record.

I gave up using the allow additions control. I finally settled on setting the recordsource as a select from statement during form open then bound the fields to the recordsource. Then when the user was ready to save the new record using a docmd.runcommand.accmdsaverecord (Create the new record)...

With the form properties window for the control source I entered "select LOCALMAN.* from LOCALMAN". Table LOCALMAN contains approximately 50 records. On this form I prefer the user not be allowed to add a new record until he or she has clicked a save record button. What I would like to be...

I am using Access 2007 on a Windows XP computer. On a form open if I set me.allowadditions = false all fields disappear on form open. Set to True then all fields appear. Data source is set to me.recordsource = "select LOCALMAN.* from LOCALMAN". All fields are bound.

MajP, I have another question. I am working on another database and I was wondering if there is a simpler way of checking to see if fields are empty. The form I am talking about contains 5 fields that must contain a value entered by the user. Can I check each field all at once or must I check ea...

I added the allowedits, allowdeletions, and allowadds like we discussed. There was some minor adjustments to the coding that I had make. Added a new field to the table and used it for the allowedits, allowdeletions. The changes did what I was hoping for. I sure appreciate the help on this...

ok, I will try this. The database I am working on is at work. I will not be able to do anything until Tuesday. Unfortuantly, the internet system at work will not allow me to post on this site. i will have to wait until I get home that night to let you know of the results.

what I did was do a clear fields command button with the following code dim varnsn as variant dim varpn as variant strsql = "select PINVSTN.* from PINVSTN where [STOCK_NUM1] = isnull(varnsn) and ]PART_NUM1] isnull(varpn)" me.recordsource = strsql I also put this in the form on load property...