Recent content by delpino

I want to program a code which changes a subform after the product_id has been entered or changed. I use "After Update" (Event Procedure). For the necessary SQL statements I need to know the primary key of the last changed record. How do I get that?

I'm running a Module which updates a table, but unfortunately it asks for confirmation of the update process. can i prevent that somehow, cause its a bit annoying to confirm hundreds of times..

There are prepared "Find Next" Command Buttons but no "Find Previous" ones. When I change "next" to "previous" in the source code i will not work. Anybody knows how to do that?

is there an easier way to do that? my programming skills in access are not very good. in phpMyAdmin (for MySQL) you just point to the textfile and execute it..much easier

Hiya.. I've got a plain textfile with a couple of SQL update-statements. updatefile.sql: UPDATE lots SET lots.cid = 1123 WHERE (((lots.ID)=23)) UPDATE lots SET lots.cid = 1123 WHERE (((lots.ID)=34)) ... how can i run these in access so that it updates my table. I looked for an answer in...

there is a syntax error in that expression..must be something wrong

how can i calculate the hours between 2 times like: 9:30 and 16:00 i want the hours between these times. PS: anybody knows if there are any freeware timesheets access programs out there?

Hello, i know this is a very common problem, but i haven't found a solution to do this. i want to format text within a memo/text field. apparently this is not possible in an easy way, without expensive third-party products. but even our old MS-DOS product can do that by using special...

I have succeeded doing it like this: Private Sub Text38_AfterUpdate() Dim number_in_form, desc_in_form As String number_in_form = Forms![lots].group_number desc_in_form = DLookup("[group_description]", "[list_of_groups]", "[group_number] = '" & number_in_form &...

This looks more like a piece of VB code than a query..could you go into more detail as to where to put this piece of code? sorry fairly new to access programming..

Hi.. i have got a table which has two fields: group_number group_description now when i type data into group_number it should fill in the information of group_description which is associated to group_number. the information which group_number belongs to which group_description is stored in...

Is it possible to use a single ADSL line to connect 2 computers via proxy? Here in our company we want to use the BTopenword Broadband for £39.99 (single computer) and use a proxy to use two computers. We called the hotline, there they told us that this is not possible. Is that true, if yes...

Try MyODBC from www.mysql.com if u have Access 2000 you will need a bug fix from microsoft (Office Service Pack)

Hello, i use access to print out invoices, but i have to change the margins in the print setup everytime. so is there a way to connect to margin settings to a form/report? and why keep the margin settings been changing?

Hello, is it possible to save zipped files in ms access?