Search results

Actually I just had time to publish yours... it works as intended so I'm not sure where I went wrong. I will play with it moreover the weekend

Thank you again for the reply - I will be home in a couple of hours and will try the DB you sent me. In answer to your question, yes, I opened the Labels database and created the named macro you setout from the 'Table' tab in there, then set the form button to run it. I will try publishing...

Attached are two databases - The standalone is my working Access database that works offline, it is what I am trying to recreate in a web database that I can publish to Access services. The second is the beginning of my web database, it just has a couple of tables, a form to run the data macro...

Thank you very much for replying - I just tried you rrecomendation with the data macro however I'm getting an error seemingly from not putting anything in the Alias field? I attached a screenshot:

I have a simple access 2010 database which is used for printing labels. I built the database using the information Allen Browne wrote at: http://allenbrowne.com/ser-39.html (I used the 'Better Solution' as he calls it) and it works great for a standalone database. I now have the need to make...

I have a form which is essentially being used as a calculator... On the form there are 2 text boxes named txtInput and txtOutput. The basis of the boxes are to display an answer in txtOutput based on a number the user puts in txtInput... There is no real calculation performed as I need to...

I created a form for viewing animal medical records using the code below which has two parts to it - the first part allows me to pull up the report between two dates (the code for this I adapted from Allen Browns website, so thank you for that) which shows eveything between the dates for ALL...

Hi Bob, I had to make an unplanned trip with work and haven't been able to do any more with my database however I will be back Friday morning and hope to get all of my data entry forms & tables completed tomorrow & over the weekend. If you are able to spend a few minutes on this tonight or...

Hi Bob, I don't fully understand (again, I am JUST learning Access) BUT I think you are correct... meaning, I will only ever have one batch of "Milk Cow" and currently there are only 2 cows that fit in there (there will be more) but yes, they will each have their own identity in the "Animal_ID"...

Thank you so very much bob

Bob, You have done enough already for which I am VERY grateful so if this is asking too much please say so, otherwise, there are two last things I am stuck with at the development stage of my database.... I am attaching a copy of my updated database (I had to zip it up to meet forum...

Bob, That was it - My mistake!! Thank you so very much for your assistance; I was able to duplicate what you showed me to create other forms & lookups tonight and think I can take it from here getting all of my data entry forms & tables setup correctly. Reporting might be another issue when...

Thank You very much Bob, I really appreciate you taking the time to look at this. I am still a little stuck though as while the 'Animal Name' dropdown on the Medical form finds related records in existing Medical & Expense entries, the idea of this page is for adding a new entry, for example...

Bob, no worries - I really appreciate any help you are able to give. I just attached the database again, this one has the forms created as you suggested so you can see what I tried and hopefully where I went wrong :) Thank You again Mark

Bob - When I look closer, it is the new Animal ID created when I select the animal that populates the Animal_ID field in Expenses and Medical tables, so, somehow I need the top dropdown to select an existing animal from the Animals table and put the corresponding Animal_ID into the new record...

Thhui - I just tried saving the database in an earlier format ant Access refuses to allow me. Sorry

Bob, I tried this and it looked like it was working perfectly, however it is creating a new record in the Animals table each time as well as in the Expense & Medical tables. Possibly something I have set wrong in the relationships?

Thank You Bob - The MsYs tables just showed up in there and I don't know how to get rid of them; I have not touched them in terms of linking though. Regarding the other, I just spent 3 full hours trying to make it so selecting the name of an animal from a drop down allows me to input the...

I am trying to create a database to manage animals on my hobby farm. Three tables are relevant to this question: 1) Animals (Contains details about the animal) 2) Expenses (Contains bill/payment information) 3) Medical Records What I am trying to do is create a form where in the first box I...