Search results

Hi, Does access have a syntax for an upsert query. I mean insert record, if key already exists than do an update of the fields for that record?

I only need to update data. No changes to schema. Just delete some rows, insert some rows, update some rows on a couple of tables. There are no forms in the mdb. The 3000 pcs have each their own "personal" db with local info contained in it. Though they all start from the same mdb file that is...

Hi, I need to update an existing base mdb database on approximately 3000 pc based systems. According to the configuration of the particular system, I have multiple possible changes that change in the database. I was wondering if there exists a program that alows me to: 1)dump the access file...

I currently am trying to do this: dim a as form a = me.form I get the following error: "Invalid use of property" Is there a function that lets you select a form using its name. eg: makeactiveform("NameOftheForm") Or alternatively if there is a function that gets the activeform. (it's for...

I have this one form that I'm using to put all kinds of buttons on. It rests always on top in my access app. (Something like the button bar in your IE) Now I have all kinds of other forms, and I don't want them to be hidden by the button bar or overlap the buttonbar. I don't want any other...

I have a form without any toolbars etc, that contains the logo of the company. It has to be always on the background. And needs to be the same size as the application window. I can't maximize the form because that means that my other forms will also be maximized. And they weren't designed for...

You know what. I couldn't get it to work like I wanted it too with this code. So I just deleted the records directly within the DB. That does work! I will never again use acCmdDeleteRecord. It's not worth the throuble. Now I use this code. Works like a charm. Dim cmd As New ADODB.Command...

I have the following code which I use to delete records.The code works just fine on my old laptop. I recently got myself a new laptop and reinstalled the whole bunch. Now I'm having the all kinds of errors thrown at me that I didn't have before. 3021 : No current record 2046 : The command...

I know that you can change the title of your application in the startup options in Access. But can it also be done by vba code at runtime?

Take a look at the file posted on this thread. It should get you started. You only need to make a small modification to make it do what you want it to do. http://www.access-programmers.co.uk/forums/showthread.php?t=63766

try it like this (plain and simple or are you planning on multiuser?): dim myrs as object set myrs = currentdb.openrecordset("Mytable or sql string") myrs.addnew myrs!myfield = "somevalue" myrs!mysecondfield = 33215 myrs.update myrs.close set myrs = nothing

thx The docmd.outputto command will probably do the job. Just one more question, is it possible to make a new document empty from within access somewhere on the harddrive? Like when you would right mouseclick in the directory and choose new->Microsoft Excel Worksheet Anyway, thanks for helping

Hi, I am allowing the user to make an export of some tables to excel, With some help I can now open a saveFileDialog which returns a path and a filename. I can also transfer tables to an excel-file But, how do you create the file itself to transfer to? or is it done automatically with the...

Yes it is. :) Thank you.

I tried to use msoFileDialogSaveAs but it appeared that that doesn't work in MSAccess. So is there something that can replace it. I want the user to be able to export a table from access to a new excel file. Does anyone know a way to do that. Maybe api or something?

Whee After some messing around I found it again on my own :) To make your program able to read numbers with a different decimal point than your own, put this function in a module and call it instead of CDbl(). CODE: Public Function CDblExt(ByVal s As String) As Double Dim t As Double t =...

I have aproblem with the range of this thing. I think I have a wrong synthax or something. I need to have the first 120 records of columns A and D The first two lines aren't records but titles So I had: DoCmd.TransferSpreadsheet acLink, acSpreadsheetTypeExcel8, "ExcelTEMP", mijnFile, False...

Nope, that wasn't the one. That one turns 12.50 into 1250 on my pc :cool: There was a way that you could convert it using a function that accepted both point and comma as the decimal sign.

Hi, Can anyone tell me again what that function was that converts a string to a double? Someone told me once before so I know it exists but I forgot :( The function recognized point and comma both as decimal point. So e.g. It would convert 5.69 or 5,69 to the appropriate decimal sign that...

How can I search to see if a folder exists with a certain name? I don't know the exact path, but I do know the directory name. Thank you, Nirious