Search results

Thanks for your replies. Mile-O The thing is I´ve never noticed this problem before. Actually, I think it´s just this one table. This is the only table I in which I enter data manually. The other tables are automatically appended (with point as decimalsign). I´ve tried repairing, but I guess...

Hi. I have a field (double type). When entering a decimal number, like 12.5, it changes to 125. I have set the decimal sign in windows control panel to point because I think that was necessary for VBA to work. Now, when I enter 12.5 it turns to 125. When I enter 12,5 (comma), it turns to...

I think you can use this as an after update event. dim sSpec as string sSpec = me.yourfield if dcount("yourfield","yourtable","yourfield=" & sSpec) = 0 then msgbox ("this is a new number") end if I haven´t tested it though. Fuga.

This is what I´ve picked up in a thread somewhere. I´ve never used it so I don´t know what it does, but there is a currentuser() function. Fuga.

Ok, I´ve read your querstion again. You can use code to get the info into variables (like the sValue) and then assign them to fields (the me.displayfield = sValue line), but it seems to me it would be a lot easier just to have a subform (an additional one if you wish), linked via the objectID...

Try this. I think it should work, but I didn´t try it. You need a field in your main form containing an identifier of the object (objectID) and a field or textbox or something to show the value(displayfield). You could probably use this as an on current event. Dim rs1 as dao.recordset Dim sID as...

å ä ö :rolleyes:

Have you checked the "advanced" tab in the import specification to see so that the field is set up as date? Fuga.

Ok, thanks. Didn´t know that. Fuga.

What does it mean when a form is "dirty".:confused: Fuga.

Sounds like an 1:N relation, where 1 computer can have many repairs(?). I would set up your db with at least two tables. tbl1 computerID (autonumber(PK)) info info info tbl2 computerID(number(FK)) arrival date problem action finish date In the first table, you have general information about...

Make an update query, in the update to row, put "raven". But if all records should read "raven", why have the field? Fuga.

Is your report based on a query? If the query is a parameter query, then you can use the contents of fields in your form for parameters. However, you say it prompts you for a couple of other things and that could mean there´s something wrong with the query. I´m not very good at reports but...

I´m not sure about this, but I think that you have to open the db exclusively to change password to it. or maybe that´s what you do when you open it with the shift key:confused: Fuga.

Just realized that you had posted this in the VBA forum, so you are probably not looking for a query. What is it you want to do? Fuga.

In a query, make a new field and put: [adress1] & " " & [adress2] & ", " & [adress3] Is that what you want? Fuga.

This works for me. Dim excelapp As excel.Application Set excelapp = CreateObject("excel.application") excelapp.Workbooks.Open ("c:\dir\file.xls") excelapp.Run ("macroname") excelapp.Quit Fuga.

I always end up having trouble with the sendkeys stuff. What exactly do you want to do? Fuga.

In sql view, I think it looks like this: SELECT TOP 1 * FROM yourtable ORDER BY [yourdatefield] DESC In design view, change the field next to the summation sign from "all" to "1", and sort your datefield descending. Fuga

In this structure, how do you plan to know which countries belong to which continent? You will need a field that links the tables. Autonumber is good because it generates a unique value. You would then use autonumber for the continents table and number for the countries table, as there can be...