Microsoft Access / VBA Forum

Hi, We are from Belgium and are looking for someone who could write us a point-of-sale (POS) software for a DVD-film shop. I like it to be in MS-Access with some VBA or just VB. The barcodes will be read through the keyboard interface, so there want be work to do on serial scanners.

I've done an Access app that does some Word automation. The code is long but the meat of it is: Sub testword() Dim wrdapp As Word.Application Set wrdapp = New Word.Application wrdapp.Visible = True End Sub Early binding, yes?

I have a VB App that instantiates a Access Application from which I have triggered the running of reports using the standard DoCmd.OperReport. This is an automated printing app that just reads parameters in a database and then just prints the report OR emails them to a recipient. My problem is that we have switched our backend to MSSQL...

I want to do some automatic searching and linking of tables within several databases that may move around or be renamed on a network system I have seen some code snippets using TableDef Connect but when i try Dim ATable As TableDef I get message user defined type not defined what am i missing?

I have a table called Services which contains, among other fields, the following: ServiceID AccountID ServiceDate There may be many service records for each account. I wish to select for each account the most recent service record.

I have three fields each containing a time unit ie direct, indirect and misc. I am trying to calculate a total (sum) of all. If the data type is 'double' number, how do I convert the total so it calculates the correct hours and mins. Or am I totally incorrect in this process? Any help greately appreciated. thank you.

hi all, i have a textbox in a form which has the property submask set to password. But now I can't retrieve the .text value whereas if I set the submask property to nothing, I can retrieve the .text value. Any idea how to solve this problem ? thx sam

Thank you Peter and Allen for your earlier responses. My goal is to update a different table depending on what record is deleted in my form. I now get the correct value but when I try to delete it says: "Microsoft Jet Engine canceled the operation because you tried to change data at the same time as another user." How can I get around...

Hello, I have a database that was available in my network, but now I got a message saying that the jet engine stopped because someone tried to change data at the same time. How can I solve this problem so I can access the database again? Thanks in advance...

Is it possible to set conditional formatting using code in a module? Thanks for your help Alex

I have a employee database with two field which are related. The field teamleader has to be fild automatically when you choose a team. This are both lookup fields from the Team-table (tblTeam - team, teamleider) How can I do this without code? And with code?

I have imported an Excel worksheet into A97/WinXPH which had the new employees names in one field ( in a Last Name,First Name configuration). I wanted to split that one field ( ) into two fields ( & ). The table I imported, , contains 61 records with a PK of . Using the Query Grid, I constructed the following query (SQL View here) to...

Hi: I have a main report that calls a sub-report which contains several pages of data. One of the column headings in my sub-report is called "Funds". If several records contain the same Fund Name then only the Fund Name of the first record is printed. If the Fund Name changes, then only the New Fund Name of the first record is printed...

I have a table TBL_NAMES : IDNAME , Name_person , ETC..... (15 different labels) I have a second table TBL_POINTS : IDPOINTS , LINKNAME_PERSON , POINTS_ALGEBRA , POINTS_GYM , etc.... (25 courses) I have made a form where all the names are listed and when i click on a name another form is opened with that persons name on top and a number...

Hi, I produce a 30 page report that has data and two charts per page, using Access 2000. My boss wants the report in WORD format. When I use the "office links" to "Publish it in Word" I get all the text but not the charts. Any Ideas?? -- Regards,

In an Access 97 database, I use serveral global variables that hold information about the database, for example: gstrFileServer - holds the server root where the database is stored gstrDataServer - holds the server root where a related data warehouse is stored The values of these variables are set when the database is opened. I want to...

An HTML version of this document is available at: http://www.mvps.org/access/netiquette.htm Feeling left out? Alone? Wondering why everyone's ignoring you? Or why you're being flamed for what you deemed an innocent post? The following tips will not only help you, they will help us help you. Please note: The latest changes to this...

I have two cells on a form. One of them is the "Production Date" and the other is the "Expiry Date". The "Expiry Date" is 183 days after the "Production Date." On an Excel spreadsheet, the "Expiry Date" is automatically entered, when the "Production Date" is entered. To do this the "Expiry Date" cell carries the following formula:...

I developed a small database for my supervisor that tracks the dates employees wish to schedule for vacation, how many days they are eligible for, how many they have taken, etc. He asked me if it is possible for the employee to email the "form" he has completed to his supervisor, who in turn would approve or reject the dates requested, and...

Hello I would like to obtain all the fields of a table where the two fields C1 and C2 from this table are distinct, what is the request ? I can't find it ... sorry, and thank you

I've got a "PlayPen" version of a production app on one user's C: drive - so they can do what-if scenarios without messing with the production data. The prod version has been running for going on seven years now with virtually no data problems. (Well, ok, somebody pulled a cable in the LAN closet once and corrupted the DB....but that's about...

Hello I would like to agregate several rows : I would like > C1 C2 C3 > ---------- ---- ---- > VINET 5 10 > VINET 5 11 > VINET 5 12 > TOMSP 5 13

In Excel you are able to write a formula =DATE(YEAR(TODAY())-1,MONTH(TODAY()),DAY(TODAY())) which will return todays date 1 year ago. I'm not sure if I am explaining this right so bear with me. Is there a similar function in Access that I can you in a text box? Thanks.

Using AccessXP I have lost snap to grid on my system. New or existing databases do not snap to grid for forms and reports in design view. Anyone have an idea on how to get it back?? Thanks. Rhonda

Hi All, does anybody have a good idea how I can run access 2002 on a Linux server ? I own a Suse professional 8.2 Linux Thanks Rolf