Search results

There is a hotel bookings database and a Calendar data base for free that I think will help you. Look at the free tutorials on accessallinone.com Sent from my iPhone using Tapatalk

You could still use ado connection to the access database... Sent from my iPhone using Tapatalk

So can you instal sql server express? If so the you can use ado record sets to do this Sent from my iPhone using Tapatalk

Does it need to be an access report? Could it be data exported to excel? I could see this being done in vba Also, Just a thought but continuous forms/reports just need the column count defined, the size of the recordset will define the rows. Let me know , your project sounds fun! Sent...

You get what you pay for. Sent from my iPhone using Tapatalk

Pluralsight.com. Sign up for a Microsoft developer visual studio membership and get free plural sight training... Sent from my iPhone using Tapatalk

[solved] Suggestions for accounting You will not believe this but your search for what you seek is free, full of utility and did I mention it is free? It is called waveapps. They have a really great receipt scanning app that is free too. https://www.waveapps.com/ If you are a happy camper...

Hello and welcome! Please feel free to ask your sql server / vba / access / excel questions.

[SOLVED] Updating related records I believe this will solve your problem. Please mark the post solved if you are a happy camper. Definition of happy camper --> http://www.urbandictionary.com/define.php?term=happy%20camper First, Will You please clarify that the way I modeled your data is...

Did the OP get the problems solved?

[solved] pivot table style I would think this is super easy in pivot table connected to access via adodb connection or something. I added 5000 records to your picture and returned a pivot table that displays your output. No code :cool: Edit:: I uploaded a version 2 spreadsheet that kept...

Yo I'm dev, is the crosstab still causing trouble for you?

Hi Minty, are you referring to the CDC technology? That is on the enterprise version but not basic version from what I can read online.

Thanks for the reply. I have been looking into the other approaches like you mentioned. When the tables are in access I can easily capture the PK using the before update event and then use that id to map audit records to the destination table. That subtle "*feature*" in access tried...

Hello, Issue: When a query is attached to a MS Access table the AutoNumber will show the new ID increment before the record is committed. When the underlying table is in MS SQL the increment does not appear until the record is committed. This link has the best information I could find so...

Hello, RE AdventureWorks2012 Any advice on how to pass a list of sub category id's to an "IN" statement, with the caviat that the list may be null depending on the user selection from an MS Access list box. Source where I did the most homework on this: http://www.sommarskog.se/index.html...

VBA code is used to set form to visible, that is when access hangs...Access probably hangs for a million reasons. I just didn't know if someone has heard of something analogous to my problem. dim oForm as form set oForm = new FORM_myNewForm ... ... ... oForm.visible = true I will try...

Has anyone heard of forms crashing access when a chart object is present? When I create the form and set record source there is no problem. When I set that new form to visible It just hangs FOREVER after it sets form to visible. Please share your general insight. I am at a loss at the moment...

I just had this problem too yesterday!! This is how I solved it and it should help you get on your way! My design tracks bank account activity but the import process is the same for any project. Ask if you have more questions on how to get going to the finish line. As of now this only...

Ok thanks Markk.