Robin, That doesn't happen if you name your controls property. txtFirstName can be referenced later as me.txtFirstName and if it contains the 0, then you ...
Robin, I didn't explain that very well the first time. You should name your controls differently than the datasource, because if they are the same name, then ...
Dear Todd, Thanks for the hyperlink reference. I guess it could give me hint perhaps. Cheers! ~Arnold~ t_hannemann2003 <mustangcoupe@...> wrote: check...
If I have a query that Totals some data, and one of the columns is a Count total, how can I (in the same query) add the value of another field to the count...
Hi! I just joined this group so don't yet have a feel for what it's all about, but hope all of you out there can help me. I, currently work for a small...
It is displayed in the VB Editor based on where your cursor is, along with the column number. Are you trying to see if every row number is displayed...
my brain aches.... I have a table called CUSTOMER which contains the customerid, customername, and a foodstuffs1, foodstuffs2, foodstuffs3 etc etc. ...
When you create your query, click on the summation key in the tool bar. Bring in your customer information. You will notice an extra row in the query grid....
That didn't work/to what I want. I don't think I explained properly. Table FOOD is a list of Products and their price. For Example FOODSTUFF PRICE Bread 1.00 ...
Robin- First, you must redesign your tables. Your Foodstuffs1, 2, 3 is a repeating group, which is a no-no in relational table design. Your tables should...
What happens if Henry wants to buy Milk, Cheese, Bread, and Beef? What happens if George wants to buy 4 Milk? Your database design limits the way you can do...
Out of curiosity, why would you need to know that? Table row numbers should not be used as a reference. Sounds like you need to add a field with an ID in it....
Thank you all for your input. I can see that in actual fact, I will probably have to redesign the database. Although I have found a solution, it is causing the...
I was in a calss once (a few years back) when the teacher said something about converting an MDB into a stand-alone application. Suddenly this is a necesity,...
Mo- You mean create an install of the app that will run on a machine that does not have Access? For that, you must have the "Developer" edition to acquire the...
... Yes you did explain it properly and John V gave the solution that IS the only way to make it work. What he is saying is that your data structure is...
... You don't have to figure it all out by yourself. Most of it has already been given to you. That is the most vital part. If you don't understand how it...
I have a library database and I would like to print reports (already designed) that would automatically start a new page for every unique shelf name (I have...
One way is to use the sorting and grouping feature and group by shelf name. In the grouping property window choose show header and footer. On the footer...
Go to Sorting and Grouping in the report design and create a group on Shelf Name with a group header. Set the properties of that section to force new page...
Hi, Does anyone know a way to set conditional formats on list box items? For example , list box with client names, if client is active, text is black , if...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
