Search results

I couldn't link the table to the main form without the subforms, because I needed to show a form view on the first tab and a datagrid on the second one. If you know some improvements on my code, plz feel free to adjust it Greets, Nirious

I have kinda messed around abit And have solved my problem like this,maybe it can helpsomeone with a similar problem: I have used my tablekey (PLUnr) to synchronize the two subforms. I first made a textfield (txtRecordHouder)on the main form (Artikels) to act as a global variable. Than I put...

I have for now just ignored the error. But if anyone knows how to avoid getting it, don't hesitate to tell ;)

Whenever I delete a record in a continuous form, acces throws the following error after deleting the record: Microsoft Access can't find the field 'I' referred to in your expression. This is pretty annoying as the delete action finished ok. Any idea what caused this thingy? I have found the...

I have a form, which has two tabs on it. On each tab, there is a page with a subform. Both subforms are based on the same table. The main form(with the tabs)is not linked to a table. Now what I want is that when I am on the first subfom( on tab1) and I am on say record 6, that when I now go to...

thx that did the job :)

Ok here it goes :) 1) how can I get the current record of a form 2) how can I set the current record of another form (that uses the same table) to the same record? 3) and if that second form was a subform in a tab-control on a form, how would I direct to it? I mean something like...

I have a combobox wich contains values from a table column with numbers in it.The number can go from 0 to 9999999999999 so I needed a double to be able to store numbers of this size. So I set the properties of that column to fixed fith 0 decimal places. I also set the combobox's properties to...

I have looked at it and looked again and again and I can't find the problem with this query. I have a textfile that I read some lines of and that are added to a databasetable: ArtopBonUpd = "INSERT INTO ArtikelsOpBon (PLUNummer, Aantal, StukPrijsExclBTW, BonNr, Input) " & _...

Is there a way to launch a program from code, and let the code wait for the program to finish before access continues? I currently fixed this by letting the user click "ok" on a messagebox to indicate when the program has finished, but that isn't very reliable, nor professional :cool: Nirious

Is there a way to get a dialogbox to only show files that start with "99". I have a dialogbox to let the user pick a file, but he may only shose a file that starts with "99". And if that is not possible, is there a commando to delete all the files that don't start with "99" from a directory?

I have a query which has a certain order when I created it. But when I perform a filter on it for use as recordsource for a report, the order they appear is all screwed up. The problem is, that I have no fields in the query that are unique identifiers. So how do I make one? It can be an...

Yeah figures, now I was so close to finishing this thing, now I get this error: Write conflict "This record has been changed by another user since you started editing it. If you save the record, you will overwrite the changes the other user made. etc..." I get three options: Save record,copy...

Yeah, I'll make it two buttons thx for helping. Nirious

I have this access application that gets its tables from other access files. Those tables are used in a form in this application. Here you can manipulatethe data. The form also has a button to show you some reports containing the data from the table. Now after a report has been printed, the...

I need to find an event that happens when you print a report but that doesn't happen when you just preview the report. Is there such a thing?

Oh, now I see. It's ok, I get it now. But can it also be done from code? because the name of the access files that needs to be linked constantly changes. :confused:

Emm, can you give me an example of that? Cus you kinda lost me there :o

What is the best way to update a table (from code) in an access-file, from within another access file? So say I have a table in file1. But it isn't open. And I have a tablle in file2. Which is open. This table is also linked to a form and when I press a button on that form, I want the table in...

I have this access-form with a button on it. When I click the button, I want a certain mdb-file (say c:\myfiles\thisone.mdb) to start in a new access window and preferably get the focus. Any idea how to accomplish this?