Recent content by Louise99

The table with the clients' names has the master field & the units has the child field. (One to Many) The source of the main report (the addresses) is clients table - master field - and the subreport is child. Thanks!

Accidentally Posted my question here - reposted in the Access Reports forum. Thanks. Thanks!

I have a report in Access that is a form letter (in details) that pulls a subreport when user sets a field to yes in a form. The form has the unit information and client code - its table is linked in a query the client table with names and addresses (to populate the details). it works fine...

I have a report in Access that is a form letter (in details) that pulls a subreport when user sets a field to yes in a form. The form has the unit information and client code - its table is linked in a query the client table with names and addresses (to populate the details). it works fine...

In other words, they don't want to type in the colon every time. If they type, for instance, 1555, I would like the cell to display 15:55 and be able to use this as a real time (in order to use it in formulas that find time differences). Is this possible? Thanks!

I have a report produced by another program that prints to a pdf. I can open and edit the pdf but the first page has a report explanation paragraph I need to remove. I removed the text using the touch-up text tool but I can't seem to move the rest of the page to the top. I tried using the...

Okay . . . I'm a dope. Thanks. Thanks!

I tried to search for this topic but came up empty. Trying to enter .5 in field. Set the field to number, long integer and changed "auto" decimal places to 2. No luck. Changed field size to double. Didn't work. So, I changed the field size to "decimal" and it finally worked. My question...

I did a search in Tek Tips on "unhide" and "unhide worksheet" but came up with nothing (didn't expect that!). I'm want to know if anyone has a quick & easy way to solve my dilemma. Otherwise I'll go to VBA . . . (in which I'm still a beginner) I have workbooks I use as quite often where I do...

I tried to search tek-tips for 'one-to-many' queries but couldn't find anything. I hope this isn't a really stupid question. I just can't figure it out I'm trying to match the numbers of consultants per service date with a table that has the service date's code as primary key. There can be...

Thanks very much MoLaker and dhookom. Your latter posts are VERY helpful (yeah, I shouted VERY). I'm sorry I shorted out a bit. I've been dealing with problems such as this: 1. Internet is down. 2. Called the help desk. 3. Put on hold by the help desk for eight minutes with scratchy musak...

I'm sorry but I'm not understanding something. Is there a problem with my posting a simple question? PHV, obviously I'm not an I.T. guru in charge of fixing the Access help or I wouldn't have posted at all. dhookom,you state "There have been lots of threads regarding this issue" but I used the...

dhookom, The help function on our network version of Access isn't working or I would have looked up the left, right and mid. One question for you - how would get the left function to return a name if all the names are different number of characters? Thanks!

I have a field with a person's name listed as "Smith,Mary" - I guess whoever created the table didn't think to separate the last name - yikes. I know how to separate this type of field in Excel(using the Text to Column). What should I do to separate it using an expression in a query? Any...

I have a table where there are many customer numbers. There could be more than one order for each on any given day. I only want to know the records where a customer orders unit #3 and THEN orders something else. So, my query output would show Customer Date Unit AAA 1/1/07...