Search results

Hello All, I have a form wherein I'd like to drag and drop multiple labels, I was able to do this for one label and figured there must be some sort of technique wherein I wouldn't have to re-write the code for every single label. A little research pointed me towards class modules and I ended up...

Hello All, So part of a DB I'm building for a Salon requires a little income & expenditure reporting. The income from every hair service needs to be recorded, as well as daily & monthly expenses (rent, salaries etc..), some payments are made by cash others by cheque/credit card. My question...

Hello all, So here's my dilemma. I work at a regional office and would like to distribute an Access Front End to all our Distributors. I consulted with our IT Dept and they wouldn't allow me to host an SQL Server that would be exposed to the net for IT security reasons, same reason why they...

Is there a way to increase the maximum allowed characters on an unbound textbox?

So as the title states, any F1 fans on here? I know it's large in the UK I searched and couldn't find a thread about it

Hello fella's, Is there a way to set/alter the position (center screen?) of an API Color Chooser dialog upon its creation? It keeps popping up on the upper left corner of my screen which I can't stand. Below is the code in the module Option Compare Database 'This code was originally...

I know many here hate to work with custom ActiveX control but entertain me please. I am using Windows XP with Access2007 FYI I started by copying cards.ocx (availabe online for free) into C:\windows\system then registering the .ocx file using the following command in cmd regsvr32 cards.ocx...

What query or SQL statement would I have to use as a multiple form's recordsource to have it display record numbers 100 to 200 for example? A solution I thought off Adding an extra field to the table, and doing this before opening the form Dim tb as DAO.recordset, counter as int set tb =...

Hello, I was wondering, where does MS Access store the backend passwords of my linked tables? I'm just wondering, if a user manages to gain access to the frontend's design, can he somehow go into certain settings or system tables and figure out the backend password? Just a security concern of...

I want to share the backend of my database with 3 different offices in 3 different cities so I'm going with an online solution. The company already has a domain that allows it to host up to 10 mySQL databases. I'm not a big fan of their interface though but I can work with it. On the other...

Is it possible to draw a line or rectangle on a form using VBA?

Hello, I'm to design an inventory/process management/accounting package for a factory using MS Access, expected number of users will be around 100. The factory manager is doubting that MS Access can handle that many users while I'm quite confident that if split and properly designed, it will...

As the title suggests, when does MS Access run out of breathe? There's nothing my clients wanted that I couldn't do or work around.. have you ever encountered a situation where you just had to reply: "I'm sorry, but this can't be done with MS Access"

I designed a database to help a company manage their events, inventory etc.. Database size came up to be around 10MB when it was empty with no records. The database is shared on the network with a few users accessing it. As data started coming in, database size jumped drastically. Last time I...

Hey Fellas, What I'm trying to do, is to have access send an email via outlook. The sendobject method keeps giving me some sort of security error which upon research I found, that it would be better to use CBO method. So here's my code: Sub test() Set objMessage = CreateObject("CDO.Message")...

Hello, What I'm trying to do in brief is to use an MS Access form to switch on/off some lights. I don't know where to start though. My bulb will be hooked up to some power supply so what I'm looking at is to use MS Access as an on/off switch. Your feedback will be much appreciated :) Sam

Hello, I have a table containing customer info (Name, Address etc..). I'm trying to generate a report that will be printed on sticky paper which is to be used as mail labels. Now this sticky A4 paper is cut down into 24 labels (3 columns 8 rows). I want to be able to print on all 3 columns...

Hello, Is there a way i could mask (password mask) an input box and make it display asteriks when users types in it? [just like in a textbox] Cheers, Samer

Hello, I have a form with like 30 text boxes, what im trying to do is (for simplicity's sake) is to run msgbox "hi" on lost focus for all 30 text boxes without having to them manually 1 by 1? can that be done? regards, Samer

Hi, I would like to know if there's a way one can launch an event when MS Access is closed (hitting the outermost close button) Regards, Samer