Search results

Hi what I do when using combobox I state in the control source property where I want it stored. On the form that field can/should be hidden but it gets the input from the combo box. That should work. Gunilla

I have solved this problem. Gunilla

Thank you now I remember. Gunill

Hi there, how do I find out who is the user. In my form I have a field where the user him/her self write in the user name. I would like that to be automatic from the user account on the computer. I have done it before, but I don't remember the code. Please help, I am totally stuck. Gunilla:(...

I think it is a good idea to post a new thread. Will you do it? I think it is a common problem as so many people are importing text files to Excel and Access. I don't know how many times I have used "mine" solution. I do agree, this is a very good place to find solutions to both hard and easy...

Thank you for showing me why I sometimes get the error about global fault. I only gets it once in a while, and I have never thought about goggle it. Of course I usually only use it once on the sheet as the information is imported from text files. Gunilla

Hi I have a VBA code that I use when I have this problem. In this code you have to change the C to whatever column you have. Sub TextToNumbers() Dim rnOmrade As Range Dim vaData As Variant Dim i As Integer Set rnOmrade = Range(Range("C2"), Range("C65536").End(xlUp)) vaData = rnOmrade.Value...

Is there a way that from Excel add a record to Access. I don't want to copy and paste as I do now. I think there is a VBA way to add a record in Access, but I can't figure it out. Anyone out there that can help me? And at the same time, where do I find the [Solved] symbol? Gunilla

Thank you Mr B, I will try it and hope that it works. Gunilla

Thank you. This did it. Gunilla

Is there a way to autosize a form according to the way the monitor is set? Gunilla:o

Why cann't I get the code to understand that if the field is empty the value is "Null"? The format is number and the default value is null. The user have to enter a number. I want a messagebox message if the value is Null (or if you want the box is empty). My code is if me!codeId.value=Null...