Search results

LOL Debbie...I KNOW I complicate things then kick myself in the rear when I realize how simply I could have done something. I'm Sherry, but all my friends call me Lucy, because of my red hair and the funny things that happen to me...I've ALWAYS got some 'splaining to do, but I will answer to...

Hi Mooredk, Thanks for your remark about detailed people! LOL ....guess that I am...maybe a little OCD carrying over? Oh, and yes, I am using Access 2010. They made a lot of changes to it and I'm not sure I like all of them!! I think I have the answer as to how to create a macro and then a...

Mooredk, that was a long time back so I'm trying to remember what I did. I did it within Access because I don't know VB. This may be a long answer because there was some extensive programming involved on the Excel end. Maybe if I explain my spreadsheet, etc, it will help to then understand...

Thanks so much! It worked!

I searched the forum and didn't see the answer to this. I am running a make-table macro. As is usual, the macro will ask the user to respond to certain things -- @ to run, existing table will be deleted, x number of rows will be pasted. Is there any way (without VB) to set the macro up to run...

Thanks CJ & pbaldy for your responses! I used your second suggestion, CJ, and it works great

I have searched through the forum but not yet found the answer I need for my issue. I'm sure there is something simple I'm missing here but.... I am developing a customers and orders database for a coffee sales company. I have, of course, a tblOrders that contains the fields 'OrderDate' and...

Oops...jumped the gun on asking about overlapping windows. Went in there and did it and now I see. Thanks for your help!

Thanks for your response. I'm not familiar with overlapping windows. Could you elaborate? Thanks

Stupid question with what I'm sure is an easy answer.... When I open my form in form view, how do I keep the right side from going all the way across my screen? I guess what I'm asking is is there a way to set the form size. I don't need my header color, etc going all the way across. Thanks!

Thanks pr2. I am trying to figure out auto-fill as I have never used that option before. Could you explain auto-fill to me? I have tried doing it using the tblProduct and the tblOrder details in a query, but I'm confused about my relationships. When I create the query then create a form...

This is a Customer Orders database created in Access 2010. tblProducts has field UnitPrice. I want the unit price to auto-fill based on product in tblOrderDetails. Seems simple enough, but I can't figure it out. I don't know VB other than inserting code someone else has created. Need to...

Thanks for your response and the code. I don't know VB but am learning a little about inserting code that someone has already written. Here's a weird thing -- even though I get the error message when I write the If statement as an embedded macro, when you actually use the form it works and...

I'm trying to create a simple embedded macro for a checkbox control on a form [Company?]. The default value for this checkbox is No. I want to write an If statement that basically says "If[Company?] = Yes, then GotoControl[CompanyorNameCombo], Else GotoControl[CustomerFN] Although the...

I actually found an effective work-around. I created the Find Duplicates Query, then created a form in datasheet view based on the query. No problems! Also, the Find Duplicate Query results (when there were any) would not allow deletions from the resulting recordset. It would say it had...

I have a strange situation here that may be hard to explain. I have a Find Duplicates query that I created with the Query Wizard. IF I run the query and find duplicates, I can close the resultant datasheet with the close button. IF I run the query and find duplicates and delete them, I can...

Thanks for your response and insight. I have not found a viable way to do this in Access, although I can do it in Excel, then import, so that's the route I'm taking. This database is for a real estate company to keep up with all their listed properties. Therefore, Address and City are the...

I have done this in Excel before, but not Access. I do not know VBA. I figure this will have to be done in a query or a macro. I don't even know if all of this is possible in Access. I need to be able to split an Address field into: Street Number Street Name Street Type Street Direction And...

I have a macro created that has several different steps, some of which include Delete Queries and Append Queries. As is natural, when the Delete Queries or Append Queries run, the end user has to click an answer in a dialog box that pops up asking if they want to do it. The answer is always...

I am grateful for the fact that you were willing to try, though.