Search results for query: *

Hi AceMan1, again my apologies. I really do appreciate the time you spend with those of us less knowledgeable. After further reading (and trial by error), I was able to determine what I was doing wrong, and was able to get it to work just like you said. Many thanks again.

Hello and thanks again for the help. I believe (pure speculation on my part) that part of the problem is that I only want the new item added to an existing table. I do not want it to open a form as there is only one field in this table, and a form to hold only one control seems a bit extreme...

Hello. Sorry for the delay. Guess I should have waited to start this thread as things got very hectic after I posted it. I will try this and let you know where it gets me. Thanks.

Thanks again AceMan. I can't believe I am still struggling with this. After following the steps and making sure the parameters are correct, I still get the "Not In List" error. I do, however, get the "Add To List" pop-up. I must be missing something, but after spending a lot of time on this, I...

Hey AceMan Thanks for the prompt reply. I did what you suggested, and F1 takes me to Microsoft help site. It did not offer any suggestions, just what the Build event does. I tried to build the event using all three options (expression, macro, and code) and unless I missing something, did not...

Hello. I am sure this very easy and I am probably overlooking the obvious. I have a form. And on this form I would like a combo box to get a value from a table. Simple, I know, if you want to limit the choices to the table. But.. If the user needs to add a new value to the list, this error...

I hope I explain correctly. I am not a website designer and I inherited the job anyway. I am trying to determine if there as method (report, etc) to tell me what files are linked to a template. Much like Quark has a 'Collect For Output' function that lists all fonts, pdfs, pictures, etc...

I upgraded from Access 2003 and imported everything from version 2003 and now when I right-click on anything in the Objects navigation pane, nothing happens. No context menu's, no nothing. I have checked all the settings, searched the forums, and even checked the MS support site. No luck. I...

Thanks PHV! That's not exactly what I was looking for, however, you were a big help because it opens other possibilities. I love this site.

I have a command button that runs a query in datasheet (list) view. I need this view for the user to see all records generated by this query. Is it possible to add a close button to this view instead of having the user click on the 'X'? If not, is it possible to create a form that lists all...

Thanks for reply. I have checked the data types and they are identical. I have also tried appending just one field instead of multiples, but I get the same error. The append to table does have more fields than the append from table, and the append from fields are also in the append to table...

Hello and thanks in advance. I am trying to append 281 records from one table into another in the same database. I know this is a very basic process aand should be easy, but for some reason, I am having a heck of a time getting it to work. The fields in the table I am trying to append from...

Duane - Thanks very much for the help, that is exactly what I needed. I struggled with this one. Yes, I guess, in a way 2b was the same question as #1. Thanks again.

This is probably too much information, but I wanted to be as clear as I could. Let's say I have a company that delivers widgets for a local widget maker, and these widgets are very bulky. My agreement with the widget maker is that I will deliver UP TO 60 widgets to a location at the normal...

Thanks for the reply. What you say makes sense. It is for reference only. So might as well leave it alone.

Thanks for the reply. The '1E+ thing' was a real 'DUH!' on my part. However, I still have incorrect sequential problem. The next record should have been four digits starting with 25xx, but instead it is ten digits starting with 99xxxxxxxx. Any help is appreciated.

Recently I imported about 200 records from a spreadsheet into an existing database. These records all had unique numbers in a number field that were sequentially in order with the MDB auto generated numbers. Now when I add a new record I no longer get the 'next' autonumber. Instead I get...

Thanks for the reply. What I am trying to accomplish is just combining two calculations into one. When I try to combine the expression in column5 of the grouped area with the expression in column1 of the report footer, it would look something like this: =Sum(Abs([main...

I reposted in this forum, as suggested. Still looking for assistance. Thanks

Alex, thanks for the reply. No it does not. If I try to use it with =Sum(Abs... I get a 'Cannot aggregate..because, apparently I cannot combine the two Sum expressions in the same calc. My limited knowledge does know how to combine the two properly.