Search results for query: *

It probably has something to do with what layout schema you has chosen for the from. If I remember correctly you can view the form in three modes; design, data and a mode with data plus design. In this later mode you can choose tabular design and another design. With this "designs" the...

Randy700, The subform is already in a tabcontrol, so I don't want to have another tabcontroll inside the tabcontroll. I lose way to much space and the links are a more elegant solution then tabs ;-) MajP, My first thought was to save the state, but didn't know how to do with the bookmark...

I have solved it now, but not as I tried to do. I have given up on trying to move the subform. Instead I save the subforms state (current record, filter and some other stuff) in a class that is global. I save the state when the user moves away from the subform and load it again when the user...

By state I mean the current record and some other stuff. I have tried to save the bookmark in a global variable and then assign it again when I reload the form. But that doesn't work, if I do that I get the following error: Not a valid bookmark (3159). It seems as Access doesn't like it when I...

Hi! Short question: How to move the reference for a sub form from one main form to another? Long question: I have a main form with a sub form. The sub form contains links to other sub forms. When the user clicks on a link the sub form is unloaded and the new sub form is loaded in its place...

We have started to migrate to MySQL, but we don't have the time to do it all at once. The thing is that the application that causes the database to lock doesn't crash. I can remove the file-handle and the user doesn't notice that I have done something. I will do a complete compact and repair...

Hi! I’m developing and administrating a big Access system with over 40 concurrent users/Access-sessions and more than 300 tables totaling 10 GB of data. This system has been in use for over 10 years. We are using Access 2000 on a Windows 2003 Terminal Server, service pack 2. The Access system...

There are different possibilities, but all (as far as I know) involve using a third partner. For example you can send sms through an email provider. Then you only need to send an email from Access. Markus

I downloaded the code and made some changes to it. To use it, copy the code into a new module. Then use the function to code the values. Functioncode1 is coded with the string Fcn1. ex. #zipcode#customernumer Fcn178541Fcn19876145 Public Function Code128$(ByVal chaine$) 'V 1.1.0...

Hi! I need to create a barcode (EAN 128) from this string: (93)7769598967(96)28781797 (Parentheses only for readability.) I have started with the information found here but don't know how to extend that code to cover EAN 128 and not only Code 128. I have tried the program that you can...

Hi! I need to validate that an email is correct and I use the following regular expression: ^[A-Z0-9._%-]+@[A-Z0-9.-]+\.[A-Z]{2,4}$ (Ignore case is true) But Access has problem with this expression. A correct email doesn't pass through (foo@bar.com). If I remove ^ from the expression...

This is the link to the page where I found the vbscript: http://www.microsoft.com/globaldev/getWR/steps/wrg_date.mspx

I have almost the answer now. I have read some parts of the link that Remou sent (http://www.microsoft.com/globaldev/getwr/steps/wrg_lclmdl.mspx). And I can do what I want with a vbs-file (vbScript), ex: currentLocale = GetLocale Original = SetLocale("sv-SE") MsgBox "Datetime: " &...

This is almost what I need. If I just could set the locale (SetLocaleInfo) with a known LCID, then I would be happy. Because then I can use the different locale settings already in Windows and don't need to write my own. So two questions. 1. How do I get the LCID that the user already has...

Thats one solution, but I need to add formateing code every time we move into a new country. I already has a table with country information. I want to add the country code from windows to this table so that it easy to switch when it's needed. It's super easy to do with .NET. But I can't move...

Hi! Problem: My company have started to work in other countries and now we are sending invoices to our customers in these countries. We want to make each invoice to be localized so that date and currency is in the correct format. I have thought a lot about how to do this in Access. So far as I...

Yes, that worked. Now I have lots of work to do. I manage 30 Access programs and I'm working with code all the time. So now I need to make sure that I close every window from here on. :-)

First time I have heard about that you need to close the code windows. I tried that on one of my programs, closing all windows before closing the program. But when I open it all the code-windows were also opened. I use Access 2000.

I think that you need to change Like 'units*' to Like 'units%'. * is only for Access and when you use ADO you need tho use % instead.

I have read that paper and it doesn't help. But I have thought about the problem and will solve it through some code that runs on the forms On Current event. Not so nice or fast, it is slower, but the users get the info they need.