Search results

Hi, I´m trying to execute an update query on a table that's in the db. The comparison records, ie the ones that are not supposed to be updated, come from a linked text file. Access is telling me that the isam doesn´t allow update to linked table, but like I said, that´s not what I´m doing...

If you do like wiklendt suggests, your table will automatically fill the autonumber field when your records are appended. Is there a reason why you want to use a make table query? So, create a table with fld and autonumber. In design view, set the field property to autonumber and assign a pk...

Hi, Judging from the first sentence in your question, I gather that you have only just now started using access or creating databases. I appologize if this is not so. However, I think in general that you should check out these topics: Relations, parameter query (update query) and vba...

Thanks mailman! I haven´t seen this until now. I will definitely try it. Fuga.

Hi, I´m going to include a real monster of a table into an already large database. The table will hold at least 10 million rows, provided it fits with access limitations. One of the fields is a date field, and I was thinking of turning it into an integer to save space and gain performance...

Good! Hope it works. I didn´t actually run it, but it should be something like that. One thing: The timer is good to use when you have a form open all the time. The timer starts when you open the form, and if you close it it stops. If you rather want to open a form and export right away, you...

Hi, I had started my reply before I saw the latest posts, so I post it allthough you need more than this. This is what I would do: Set up a form. In it´s timer() event, put in something like this: Private Sub Form_Timer() Dim exportdate As String 'check to see if it´s friday If Weekday(Now)...

You can automate msOutlook to send emails with attachments. If you need to do this every 24 hours or so you can use a form´s timer event. To export a query to excel format you can use TransferText. Are you familiar with vba programming? Fuga

You can do this if you have your participants info in a mainform, and the different questionaries in subforms, linked by the ID field. Is that what you´re looking for? Fuga.

Hi, At the risk of missing something here, can´t you just do it like this? variable = right([Emergency-Approver],5) and then do a select query: select * from approval_code where [field] = variable Fuga.

In access VBA, I usually use docmd.transfertext or docmd.transferspreadsheet to accomplish this. I run this from access rather than from excel, but using VBA I think you should be able to run it from excel. I´ve always done it the other way around so I haven´t tried it, but make sure you have a...

Sorry for the delay. This might have to do with the importing function. I´ve had similar annoying problems. Try making a manual import of the files first (thus pointing in the right folder). Then run the loop and see if that helps. You will probably need to check your loop as well. It looks...

Hi all, I´ve had this problem for a while but it only just recently became very annoying. I have a chart on a form displaying data over time. I´m using two comboboxes to select start date and end date. There are A LOT of data in the underlying query. However the problem does not seem to be...

Hi all, I would like to have a function in an access query showing the slope of a trendline (the linear one in excel). Do you know how to create it? Fuga.

I use the Dir() function for finding the files and I would think there is a name method for currentdb.tabledefs. I'm sorry I don´t have time to test it right now, but check out the help for dir() and the tabledefs collection. Fuga.

I thought I´d share my latest experience. The formulas I had problems with started quite "late" in the workbook, meaning that the first 1000 rows were empty in the formula-columns. I tried putting a number in the first row, and it seems that access now links correctly. This would indicate...

Hi again, First, I solved the problem temporarily by selelcting all, copying and paste in as values. Then excel saves a copy of the workbook. The workbook with the formulas stays intact. Not pretty, but then again this should have worked in the first place. I like microsoft´s programs, but I...

I´m new to web programming, but wouldn´t Microsoft´s visual web developer with access or sql server be worth checking out? Fuga.

ok, so now I tried boblarsson´s suggestion, and I still get the same error. What am I missing? Fuga

No, I don´t. I have been messing around with different versions of office. perhaps the file is somewhere else. What is the name of the file?