Microsoft Access / VBA Forum

I need some help on two problem I'm working on. First, I have an option group button with a checkbox called Inactive that allow me to open up a new blank form and input new record, but the problem with it is that once I input new record and save it, I can't go back to previous record, In order to view all my record, I have to close and...

I have a split Access 2000 database that I've been asked to secure. The data is sensitive and users include programmers who are routinely accessing the data directly, so I plan to remove all permissions from the tables in the backend and then create RWOP queries to retrieve all the fields in the tables so users are limited to the column/row...

I have a database that someone else put together to maintain. Security is handled via group membership in the System.mdw file. Some groups have data deletion rights to a particular table while other groups don't. One change involves flagging a record as deleted instead of actually deleting it. Not a problem - except that I don't want groups...

i have a table with a field. table name = tbl field name = fld fld abc bda cdfd aadr

sir, I am working on Oracle 9i on Linux. I have a simple clarifications to be made.. Is there a concept of replication in MS ACCESS ? If yes, Any GUI Tool available for it ? Thanking in advance ... regards,

Hi I am developing an application in MS Access 2000 that is to bolt on to an existing Access database, that links via ODBC to our UNIX-based factory management system. I need some help in this area as am not a VB programmer, and I try (where possible) to keep everything to simple queries etc. We have orders that have to be scheduled for...

____________ ||||Winners|||| ____________ Best Drool: ======== David W. Fenton Tony Toews

Hi, I'm developing a site with a public and members section. I'm using vbscript, asp, and an access database. The login page is processed by the members page. If you are a valid member the member page loads. If not the member page redirects you to the restricted access page. On the restricted access page I want to run a script that...

When I try to create an application in swedish everything works great up to a point where the wiz says that it is missing certain language specific stuff, and asks me to put in the MS Office disk 1. I do so, but the wiz can´t find what it is looking for. What is it that is needed here? Under tools I find several languages, but not swedish,...

This is an odd problem, when upgrading an application from 2000 to 2003, two of the forms have most of the control's Visible property set to false. What's really bizarre about this is that opening the database in A2k works perfectly and then opening a copy in A2k3 displays this behaviour. Any ideas?

Hi there, This issue was reported and discussed long ago in 2002. I was wondering whether there is in the meantime a simple solution or fix for the problem that in Win XP fonts are differently displayed. Thanks! Sabine

Hi there, I have the following challenge ahead, can someone please offer some advice?: I have a database with several peoples' measurements. I created the following table structure: 1 main table, containing the persons' personal details, age, etc.

Hello all, I am converting an Axs 2.0 application to a2k (I know A2K is not the most current version but Axs 2.0 support ended and A2K is supported in our company amd on every PC). The form is part of an access projcet (ADP) and runs against SQL Server 2000. I have an bound form in endless view which contains a header with a combobox....

I have been working all afternoon developing a database and then disaster hit. I accidently typed a "d" in a property field and didn't realize it and closed the window. I am getting the following message. "the Microsoft Jet database engine cannot find theinput table or query 'D' Mkae sure it exists and that its name is spelled correctly."...

Hi all !! i get a new trouble with my project. My english is not good, so my interpretation is not clear. In my project i have 2 forms: main form: F1 base on table: T1 with MAHH is primary key. sub form: F2 base on table: T2 with MAHH is foreign key. F1 and F2 link by a button(ToggleLink) my goal is when i type a text in MAHH of F1 after...

I'm in the process of building a site packed with video tutorials on a whole range of popular software applications but need people interested in recording screen tutorials for a 50% share of the sale price of their contribution. We are selling 5 minute tutorials for about $1 US and will be giving half this sum to the tutorial author each...

rr@kristin.school.nz (Wayne) wrote in message news:<7ec36840.0403301824.16f2cd9f@posting.google.com>... > I have a subreport in my report and when it contains exactly one row, > it works fine. In every other case, it displays all but the last row. > The subreport grows large enough to show this last row but leaves it > blank. > Can anyone...

I have loaded on my computer Visual Studio.Net Enterprise Architect 2002. I want to load Visual Studio.Net Enterprise Architect 2003. I really don't need VS.Net 2002 and was going to uninstall it from my computer. First question do I need to know of any problems that might occur if I uninstall VS.Net 2002 then install VS.Net 2003. The...

Hello all, I am attempting install MSDE remotely, using two Win XP machines, both with Office 2000 on them. When I install MSDE on the server locally, there is no problem, however, when I attempt to install MSDE on the server from the client machine, there is an ODBC error. What baffles me is that the machines can see each other in windows,...

I've dabbled with VBA in Word and Excel and generally can get what I want accomplished but I'm having trouble in Access. Mainly with how to identify the location or address of where a particular bit of data is kept. I have a database with a main form for data entry. There are queries that I have that will bring up various types of data on...

The only solution to penis enlargement!

Hello, I have a list box with some predefined options. I would like though not all of these options to be available for each user... Is this possible? I assume that every time your create a new user you have to specifically assign his available options... thank you in advance Laertes

My form has "Arrival" to be filled in by user. I need a report of all the arrivals for the next 7 days. In MSWorks database, I used => now() and <= now()+7 to filter, naturally it doesn't work in Access 2000. Is there a comparable command? TIA

Problem 1 - I have a query setup to run a report. How could I filter out some record from a field called Status Effective Date from my report only if it is 30 days prior to when the report is printed. Problem 2 - I'm trying to make a field a required field only if a condition in another field is met. Example: I want to make Target...

Hi, I am using the following code... I want access to check to see if field 'despatched' is already TRUE, if it is true then I would like a msgbox to popup saying 'already despatched' then 2 command buttons, one to cancel and not overwrite the details, the other to continue and overwrite old details with new ones. Thanks you....