Search results

Sorry - but I don't know what you mean by "unicode enabled db."

Database doesn't actually lock up to view, but can't add new records to the main table

I have a database used by about 15 users. Occasionally a record appears which contains strange characters in it rather then regular text and numbers. The solution is to compact and repair the database but this means taking all users off the database. But I need to find out how these...

Make sure that you get both of the single quotes in - theres one after the equals (before the double quote) and one attaced on the end (between double quotes) - copy and paste this line DoCmd.OpenReport "ChildDetails", acViewPreview, , "Childs Name = '" & Forms![Child Details Query]![Childs...

If childs name is a string or text field then try including a single quote as follows: DoCmd.OpenReport "ChildDetails", acViewPreview, , "Childs Name = '" & Forms![Child Details Query]![Childs Name] & "'"

Trouble is - the reports are acually letters and I need the user to be able to have any number of different letters based on their client requirements, so it is not feasible to have just 2 reports, because it may be that they need upto one hundred different letters.

I need to be able to change the margins of a report from VBA based on values selected by the user from a form. PprtDevMode allows you to change orientation etc but not the margins. Any help would be appreciated

I am attempting to put a reminder in my Outlook calendar from a button on a form. Below is the code I am using, but I am getting "compile error: Method or Data member not found" on the CreateItem. Dim objOutlook As Application Dim objAppt As Object Set objOutlook =...

Yes - put it in the AfterUpdate event of the listbox.

Try the following if listPaymentType = "Cheque" then me.txtChequeNo.enabled = true else me.txtChequeNo.enabled = false endif

My db is very big now so not sensible to post it! Had a quick look at Northwinds - nice simple example - I wish mine were as simple! Just had a different thought on the problem - when I click on to the main form, I see the 'pencil' indicating the record is being edited - do you know if there...

Thanks for the syntax - I've already got the syntax correct for refresh, but this doesn't seem to be the problem.

I've tried that already - but I still need to update the field twice!

When I update a field on my subform, I use the AfterUpdate event to calculate a new value of a bound field on the Main form. I have to enter the new value on the subform TWICE, before I see the new calculated value on the main form. Any ideas? Thanks in advance.

Thanks for your reply - I've not had any problems until now. The line that went wrong on this database uses LinkChildFields. Unfortunately I'm not in France and cannot see the problem myself - but I will pass on your comments.

I have a database which works well on local PC's. This has now been copied onto a PC in France with french installation of Access. The following error message occurs "Le parametre entre n'est pas cette propriete" (The entry parameter is not valid for this property) It has been tried on...

You could try something like >L<????????????????????????? which gives you a capital first letter and then upto 25 lowercase letters

Try using Input Mask instead

I have discovered that this is a known bug http://support.microsoft.com/default.aspx?scid=kb;en-us;811860&Product=acc2000 The fix for the Close command is as follows DoCmd.Echo False DoCmd.Close DoCmd.Echo True This Works Hurray!

Thanks for your suggestion. Have now done this. I have now discovered the following: (1) If I run the form from the DB window it works - great. (2) BUT when I run it from a command button on my main menu form it comes up with the parameter value!! Is this a bug in Access? (am using Access 2000)