Search results

Thank you. That worked great. One more little thing. It formatted the date like this: 12/28/1944. That is fine, except some of the people born in the twenties got birthdates like this: 2/21/2028. Is there a way to get it to just do dates in the past or something like that? (I added 1900 to the...

The dates in my table are strings that appear as 12305 (1/23/05) and so forth. So some are 5 and some are 6 digits depending on the 1 or 2 digit month. I want to convert them in my query to a date field. I think I have to use the DateSerial and extract the parts of the date, but that leading 0...

I want my text box to display a social security number like this: "*****6789". 5 asterisks and last four numerals displayed. I am familiar with the "Password" Input mask but I think it only allows the entire field to be masked. Can I make a custom mask like this?

File Size Growing I thought i would reactivate this thread since it seems closest to my problem: I have an access2000 db that queries another db every few seconds to create what appears to be real-time data on a form. This is used for dispatching. I use a make-table query to pull the most...

Can you arrange records in columns on a continuous form? When I select Columns in Page Setup it seems to only affect the print layout. I want to be able to view my narrow details in two or three columns across the screen instead of scrolling down. Is it possible?

ChrisO, I think I understand what you are saying. First of all, I cannot alter the original table from where the data derives, however, I have made a new table and added the "date paid" field as you suggest. SO I can bind that field to the form as a null value, but then how can I create some...

That looks like exactly what I want. I see that the check box is coming from the table. If the table I am using does not have a field like that, is there a way to add one with a query? Thanks so much for your help

Oh, that's not what I wanted to hear. Any other ideas to accomplish the same thing? The bottom line is: I want the user to be able to view several records from a table or query and be able to select certain record(s) and perform a function like an append to another table with just those records...

I have a continuous form based on a query. I would like to have a button or control that performs some command on only one certain record. In other words, the user sees the record he wants, clicks a button and it changes the value or changes the color. When I add a button to the form, it appears...

I somehow got the subform to work, but now I cannot enter a new record because the name boxes are bound to the query. Here is a sample db that represents the one I am working on.

Can someone please help me with NO CODE please? I have a CustomerID table that is linked one-to-many with a DailyEntry table by CusID. I would like a form that allows the user to type in the CusID and the names will autofill from the CusID table. I also want the subform to display all the...

Thanks for #1. My only aversion to code is that I am clueless. But, I have to start somewhere, so I will give it a try. Meanwhile, besides this forum, any suggestions on where I can learn the basics?

Still having trouble 1. the asterisk as a default value did not seem to work. Any more ideas for number 1? 2. I still cannot find any way to get a list box with multiple values to go into the query criteria. Is there a way to do this without code? How come referring to the list box as a...

Two questions: 1. I am using a series of combo boxes to set parameters in a query. If no value is selected in the combo box, I want the query to ignore it or pull all values in that field. What it seems to be doing is treating a blank combo box value like null, which returns no values in my...

That last one did the trick. Thanks!

How do I convert a value like 134 seconds into "2:14". My table has a field of values like this that are numbers and I need a calculation in my query (or report) to change it from seconds to minutes and seconds.

I asked this in a different thread and got no replies, so I am trying again in case it wasn't understood. I want to calculate time differences between time fields in two tables. The start time and the end time are in two different tables, but there is no other unique field in both tables that I...

That worked great! I do have a primary key field, i just wasn't using it. Thanks so much. How about another one? Similar, but different. I want to calculate time differences again. This time the start time and the end time are in two different tables, but there is no unique field in both tables...

Sorry my reply took so long. i cannot attach anything from work, but here are more details. My table has device number, date/time, amount, and other stuff. I need to find transactions on the same device for the same amount that occur within five minutes or less of each other. This must include...

Page Setup problems I am having the same problem, but i cannot find the feature to which you refer. I looked it up in Help and only found an AutoCorrect feature which does not seem to be the answer. Can you direct me to the right place and tell me if it will solve my problem with changing...