Recent content by LaurelLee

Definitely try the technical staffing route. They have been my life savers throughout the economic slump. A month here, two weeks there, and usually at a fair rate. Better than nothing, and it might get you a full time gig. Good Luck, I know what you are going through...

I worked as a technical writer for some time, and I am sad to say that I discovered most people had a fairly narrow vocabulary. My boss had at least one objection per page for work that I submitted to him. I came to the conclusion that he did not know what I was referring to half of the time...

Yup, it is official, I need to go home. Thanks! ___________________________________________________________ With your thoughts you create the world--Shakyamuni Buddha

I am attempting to write an if statement something like this: If DLookup("FridayDate", "qryGetFridayDate")=Now() then do something. This is never evaluating to true because, as I see it, now() includes the date and time, and my field is a short date. So, I tried this: If...

I don't know where you are located, or even if this is free, but you can look into Cragslist.org. I know everything else is free to post, so maybe job listings are too. ___________________________________________________________ With your thoughts you create the world--Shakyamuni Buddha

Okay, so I would add the date to the table and then check to see if it was there when the database was opened each time. That makes sense to me. I was definitely thinking that it was going to be more than that. Thanks. ___________________________________________________________ With your...

I need to execute a query and append to a table once a week, on Friday. The problem is that there are a lot of people using the database throughout the day, and when it is Friday (like today) I do not want the table appended to every time the database is open. Any suggestions on how to go...

Okay, that is what is going on here. But do you see why there would be an error occurring when a selection was made? The debugger highlights the line Me.Action.SetFocus when it happens. I don't want to mess with this form very much, as I have other things to do in the Db, but it looks like I...

I have recently been thrown back into the wonderful world of Access after a brief break, and have inherited a Db. It is a fairly straightforward applicant tracking db for and HR dept. On the form used for inputting new applicants into the db, I have encountered something curious. When the...

Philote-- Thanks for that great link. I am in the job market now and know that I need to hone my interview skills. That site will definitely help. Cheers! ___________________________________________________________ With your thoughts you create the world--Shakyamuni Buddha

Is your form bound or unbound? If it is bound to a query, calculate this value in the query, call it PageSum, and then do as Crowley16 said and put "PageSum" in the control source. Explain a bit more detail if we are missing the mark...

Can you see the vertical line in design view, or does it only pop up when you are running the report? ___________________________________________________________ With your thoughts you create the world--Shakyamuni Buddha

madelca100 -- Good to know! I always had a suspicion that I was using the wrong word, and apparently not too many people realize that acronym is incorrect. Now I can dazzle my freinds with that one. I will now take up your crusade to correct the misconception! [smile2]...

Instead of placing the query in a text box, you need to place the fields you want in text boxes. Then, in the Properties window, pick the appropriate control source. If you already set the recordset, the control source box will drop down to reveal the fields from your query. Does this help...

I guess that change can be hard to swallow sometimes. Acronyms that have been around for ages are easily accepted, but newly invented phrases and acronyms are easily stumbled over, which is where I see the problem being (not that that is a REAL problem :)). If they stand the test of time, they...