Search results

i have sometimes come across this request where users learn the numbers and want to enter the number instead of the name. You can have a table of city names with an autonumber primary key. In the combo, you can use a query that shows both the autonumber pk and the city. Make sure the 1st column...

Here is an A2007 copy of the simplified word merge database based on Albert Kallal's WordMerge22.

Removed the attached database because it wouldn't open in A2007. Here is the database modified for use with a single folder and word merge template. On your computer, put both the database and the word folder with its 2 files on your local drive or desktop and try it out just as it is...

OK. Give me 2 days to do this and I will post the code for you to try.

Here's the link to the microsoft website that lists the fixes and changes in SP1 for Office 2010. A full change list can be downloaded from Microsoft's website (download Excel workbook)

Here is the link to SP1 for A2010, released 29/6/2011 http://support.microsoft.com/kb/2460049 Here's a link to an article about sp1 http://www.computerworld.com/s/article/9217989/Microsoft_delivers_Office_2010_SP1_upgrade?taxonomyId=89

This has become confused - hard to explain so much in a post. It would be easier if you posted this database as an attachment and I will have a look at it. Remove any sensitive data and replace with dummy data before you send it.

Yes, of course. Post back with the code you have written and show the bits that don't work.

Sorry, but I am do not use the type of code to automate word as shown in Helen Feddema's code you posted. It would be easy for me to help with code that I know quite well - Albert's code. Please create a new question on the forum asking for help with code written by Helen Feddema to automate word.

This sounds like a lot of work - to create 2 forms with buttons and code when you could do the data entry all in one go in one form. I suggest that you make this first form a bound form and save the data in the table. When you open the second form, it will be bound to the same table, so the...

You can use IsNull. In the form's before update event, code something like this: If IsNull(Me.[Textbox1] Or IsNull(Me.[Textbox2]) Or IsNull(Me.Textbox3]) Then Cancel = True MsgBox "You must enter a value for every box." End If. To make this code run from a button, code the button like...

Here is a method that lets you find the errors. Dim strSQL As String strSQL = "Update Telecalling_database set Calling_end_Date_time = " & Me.timer1.Value & ", Paid_Unpaid_Status = " & Me.Paid_unpaid_status.Value & ", No_of_Premium_Required = " & Me.No_of_Prem_required.Value & "...

I have answered this same post, which somehow was posted a second time.

If you wish to use the accdb format, you need to create your own table of users and user groups. Build a login form. When a user logs in, grab their user id and their user group and stick these on an always open but hidden form. Then for all your forms that need to know the user's group when...

Here's a link that shows how to mail merge to word, and as a bonus it also shows how to include an excel chart in the word document. http://www.rogersaccesslibrary.com/forum/topic396.html There is a great little database by Albert Kallal that makes it easy to do word merge from access to word...

You can put a textbox on a form called txtRecCount On the current event for the form you can put code to count how many records in the form. Me.txtRecCount = Me.RecordsetClone.RecordCount

It you look closely at a subform on a main form or on a tab control - you can see that the subform itself is inside something that looks a bit like a very large textbox. To see this more clearly, in design view, first click on the main form. Now click once only on the subform - you should be...

Now it's my turn to say 'I don't understand'. What do you mean by 'Thats nice but I still don't understand how to click something on the search results and get the profile open. (without changing forms). ' Search forms are built for searching, they are not built with data edit and entry as the...

I can help with Single forms - but no experience with split forms - all my apps use plain vanilla forms and have done for many years. A2010 has an option to display forms as tabbed forms or overlapping windows. When you select tabbed forms, the form sizes itself to fill the access window. If...

Yes. Put the code in the before update event of the form. If lngCount is greater than 0, then use the cancel parameter built in to the before update event. Something like this: If lngCount >0 Then Cancel = True End If Of course, you will need to add some code that checks if the user has...