Search results

>>True, I could test this theory myself, but I'm concerned that there might be conditions where it could be troublesome<< The test did show favorable results. my concern was under certain conditions, it might not favorable. Also, somewhere in the past. I thought I had read an article in regards...

Yes, this is definitely better than what I had hoped for. Thanks for the help. Bob

At times I trust Dragon more than I should. Case in point. There are times I query by size and average or both. Wow. I see what you mean. Bob PS you didn't answer my question. If I'm going to calculate I'm going to need something other than text.

I'm looking for a way, when entering form, to force a field to accept a value, rhs;jjc;cjs. then every record will automatically contain the accepted value time you go to a new record. That would only be for newly added record. It would stay this way tell exit forum and the next time is open. It...

I have a field that will only get numeric values, numbers. And it will always have four characters or less. I do have times when I worry my data by over eighty's certain size or I average value, or both. Is this possible when using a text field. So I'm looking for advice whether I should text...

Thanks for the help. I used the word "General" in Format and got it exactly as I needed. I did it in the forum. I would like to know why would I want to do it in the Datasheet View or Forum. It seems if I always want a certain format I would use Datasheet View. If I was planing on using it in...

I have several visual dBase tables converted over to Access 2013. The old tables use identification, SEQ. I have retained the old SEQ , but now have the Access ID. It seems I somewhere saw that if you delete an ID, you will be changing all the subsequent IDs that follow. In other words, if you...

I'm using a form. Would I make these changes in my table or in my form. I would do a test, but my results are not very exacting. Bob

I want my table to accept only certain values in a field. I tried different things with no luck. Field: OCC (except only 1 or 2) I tried Validation Rule using Expression Builder, which did not work for me. I also tried creating a default value of the same field. What I'm trying to do is have...

For a link this is probably the best example I've come across, making it very easy to follow. Thanks for the help. I also took advantage with the help on the start up forum. As easy as it was you would think I would have done this a long time ago but I never knew it existed. I also looked at...

My correction for the problem was to delete the label, copy and paste a different label, which gives me no connection. You would think Microsoft had a better solution for the problem. Bob

I did get it to work, thank you. And it does show the a.m. and p.m. But! If I go into Datasheet View, it only shows the time. But if I enter the field, it will show both the date and the time. Is there a way where I can see both date 7 time at all times. I'm also concerned if I will have the...

I have gone to layout\remove layout and for the most part it works. But now and then I have labels that stick to the field. Not always just a couple here and there that make it impossible to work with an entire column of. Bob Access 2013

I have set up a form and only want to display the date and time that will appear automatically based on when the record was created. I definitely don't know how to do this. The format that I'm looking for is: 07/24/13 11:45:44pm from what I can see I would need two separate fields to accomplish...

i did eliminate the problem by going back to the original computer, file. But I definitely have to do this, "have you set the Trusted Locations on the new computer yet". I have never used this function before. I would imagine I would be doing it on the main computer. Would I be doing it based on...

Label and text box not working. I'm building my first form in aCCESS 2013. I've laid out all my fields and moved my labels around and now I'm trying to add a label or a text box. I can drag them down to the form and drag out a size but when I release there is no text box or label. I don't know...

I did read your part one. I did not get to 2,3 or 4 yet. this is kind of what I have already done. I was under the impression that once these tables are linked, connect, normalize whatever term you want to use that I would be able to access fields from the other tables. That's my only concern. Bob

First not for the day, forever. So I have no experience. I have my fields laid on the forum, but I want to have a field showing from a different table. How can I link the table to this form so I can do this. Also, I'm uncertain if this is a good idea. So I'm looking for a heads up: my table is...

I am creating my first form and a field that holds a price is showing that as 000000.00 I would like to eliminate trailing zeros and can find nowhere in a properties to do that in form properties. Bob

I'm creating a form, and all the fields moved together. How do you unlock the field so you can move each one individually. I don't need them in columns as they are, nor the same size. Bob