Search results

Hi All! I'm retiring from the military in 5 years, what are some great technology areas to get educated for? I'm currently working on getting my math up to speed. I know I'm interested in devices, robotics, and user interfaces. I like a combination of sitdown, get up and make stuff, with lots of...

I did =) after seeing the replies from the forum and it did help. tBenchstock tOrders tComponents tEquipment currently I have queries combining Benchstock&Catalog Orders&Catalog Components&Catalog Equipment&Catalog So far, it is working alright, could it cause issues later? Need to pull...

You are not alone! I was the IT gal for my horse rescue for 5 years. I started them with MS Access and migrated to SharePoint for the reliability and being able to access records and reservations off site. I did learn a lot. I am very grateful to the forum for all the help. Thanks for posting.

I agree on the tCatalog, but T Catalog is the main list to describe the items in Benchstock, Orders, Equipment, Components. Any ideas other than making and maintaining identical matching TCatalog tables for each list? Thanks on the IDPersonnel, I did see that and corrected it. I solved my...

Hi All, thanks in advance I maintain military equipment with inspections coming up requiring printed forms. tblPersonnel tblEquipment tblComponents tblInspections tblCatalog One person has many equipment. Each one (tblequipment)equipment has many (tblInspections) has many (tblComponents)...

HA! THANK YOU SO MUCH! and I tried that one before too, and the syntax must not have been correct! I am so excited cause I learned something new =) see teach us newun's to fish and hopefully we can help other folks this is the code that works in case anyone else needs to know Private Sub...

The following code shows an error, the button is located on an unbound form, but I wouldn't think that would make a difference since the Form "SPBookings" with the ctl "ID" is being opened first Private Sub Command0_Click() DoCmd.OpenForm "SPBookings" DoCmd.OpenForm "Find Bookings Form", , ...

Thanks guys, I tried this: DoCmd.OpenForm "Find Bookings Form", , , "BookingID = " & [ID] and got: Run Time error "2465": Bookings can't find the field "l" referred to in your expression and then I Tried DoCmd.OpenForm "Find Bookings Form", , , "BookingID = ID" and got a message box...

This has got to be easy but I have tried lots of ways to get it done...:confused: I have two forms, "SPBookings" field[ID], and "Find Bookings Form" with field (lookup field) [Booking ID] and my macro, on button click located on SP Bookings. This does fine to open and filter records. The macro...

That's ok I solved it, will post the solution in a few days thanks!

Oh I second that, any suggestions on a query? Where to place it and how to execute? Sql is my next learning curve Could I get a possible example? And question, how would the query know which contacts are just entered and belong to the details table? My tables are related by Bookings> Details>...

ok so I have two forms open: One is a SP Bookings form with a subform SPDetails Query subform. The other form is the not connected/related SP Contacts Query form, to which users enter Full Name weight age ect. Need to copy the names of the new customers Full Name to the Lookup Contact Column in...

I don't have MS Access 2003, unfortunately. The database worked fine when I was able to set up a copy of a normalized database with Ms Access 2007. But using the lookup fields with sharepoint throws ms access for a loop.... so I need to find a way to get the new customer information from the...

https://plus.google.com/u/0/photos/117081647515742386389/albums/5943924748943630913/5943924756043350994?pid=5943924756043350994&oid=117081647515742386389 hmm still getting the error message.... here is the process I am hoping for... 1. Open the SPBookings Query form and SPDetails Query form...

I have a vba coded button on a blank form that opens SPBookings Query and then opens the SPContacts Query form. I'm helping a horse rescue and that isbwhat this app is for:)

ooh thanks for the suggestion, just to be certain, I would put this in a module and have the module triggered on After Update of the Full name column on the SP Contacts Query Form? Additional info---SP Contacts Query Form (pop up mode) is what we are using to add records to the database...

Ok so I have looked for hours for a solution to this problem. I have an Add New SPBookings form with a subform SP Details Query. SP Details Query has 5 columns, BookingID, DetailsID, Lookup Contact, LookupContact:ID. I also have a popup form called Contacts Query. How do I get new records...

I would like to be able to email to customer a invoice HTML or pdf, with ms access web 2010 site over sharepoint 365. Will I be able to do that? Will it have to be on my pc or could I possibly do that from my mobile phone? (android)

Hi has anyone tried to use ms web access to sharepoint on a mobile phone? did it work ok? was it slow? I would like to make a small invoice system, and make forms with buttons that are mobile friendly so just wanted to know

I had to do it like this: I set up a form, with a query expression that said " 2All info:("Name: "&[name]& "Age: "&[Age]"Weight: "&[Weight]) and so on until it read John Doe Age: 76 Weight: 150 Then I have a column on the table called All Info. On update or on load of the form I have a...