Recent content by SGT68

Okay, I'm getting the idea of what you want. In order for me or anyone on this forum to help you, they will probably need to have your database, I don't have the time right now for that, sorry, but re-post this question in the Forms section and somebody should help.

At the bottom of your form there should be navigation controls where it says record 1 of whatever number. To the right you should see a little yellow asterisk. Hover over it and the tooltip will say "new blank record".Can you click on that. The yellow asterisk is the button you need to use to...

Need more info, what kind of error messages if any are you getting?

Go into the Create menu and use the form wizard.

http://eu.wiley.com/WileyCDA/WileyTitle/productCd-1118490355.html a very good book. Otherwise see if you can adapt one of the template databases, which are complete with forms for your needs. By reverse engineering it and seeing how it fits together you will learn a lot

I have created an app that is used by me, and two other users. I have split it into 2 files : tables in one file and everything else in the other. I need to put the tables.accdb file on a network drive and link to it, but we do not have a network. Are there any cloud solutions that provide...

us version http://products.office.com/en-us/business/compare-office-365-for-business-plans

Hi Bob, You need an Office 365 Business Essentials account. Thats the cheapest option to create Access Web Apps. Included in this plan is Sharepoint with Access Services which is what you will need. http://office.microsoft.com/en-gb/business/compare-office-365-for-business-plans-FX102918419.aspx

ok, great I'll get that done tmrw. However now I've discovered an issue: The SQL Server I'm using is a WINDOWS AZURE SQL DATABASE on (Sharepoint with Access Services). I've connected to it with my desktop SSMS but being and Azure type it doesnt have the same Views applet that a normal SQL Server...

From design view the queries run ok, even the nested ones. How would i post a query for you to look at?

Could it be that some of the queries are made up of queries? Could it be that some of the tables use compound keys, which I've heard some of the Access greybeards frown upon?

Minty, Tables joined , between 2 and 5 records returned: in the hundreds. View in the backend, yes thats what i was thinking. Never done that before, I will have to use SQL Management Studio, right?

I have converted an desktop Access database to SQL server. A medium sized app with 24 tables, 60 or so forms/subforms and about 120 queries. I created 2 split files, one containing the tables, and the other containing forms, queries, vba modules. I migrated the tables to SQL server using SSMA...

I'm using Access 2013/64bit. My form needs a control which is a select file dialog. Where do i find this control? I've googled and the results were vague at best. I'm guessing its an active x control and i have to reference it in. That's all i know, help pls I need it cos the user has to...

I don't do light topics, so apologies in advance lol... I used to be afraid, of death, really afraid. The thought of it would practically give me panic attacks. Most people are scared of death to some extent, but my fear was extreme. But then, about a year or so ago, something occured to...