Search results

Hi, What command & arrguments can I use so that I can open a database on my computer using a macro written in another database? Thanks

Hi, I am trying to write a SIMPLE database to load on my co-workers desktop that would allow him to open whatever application they desire. I know I can use a switchboard for this but I don't know how to write the macro to handle such a command. Example: The user would open the 'switchboard...

Hey, I have a small question. There is a table that I am trying to use that houses product numbers, the only problem is that those product numbers start with a '0' but the '0' got deleted because the numbers are housed in a number defined field. If I change the table properties to text, is...

Hi All, I have a small yet important question to ask. I have a text box on a form, that text box accepts a product number that the user wants to modify. I want to be able to do the following: - If the product number does not exist, prompt with an error message (this part is not a problem). -...

Hi All, I have a small yet important question to ask. I have a text box on a form, that text box accepts a product number that the user wants to modify. I want to be able to do the following: - If the product number does not exist, prompt with an error message (this part is not a problem)...

I have been away from access for a while now and I am sure that this is simple. I tried a search but found nothing. The issue: A)The user enters in a product number, if not found then a message appears to tell them so...this I know how to do B)If the product is in the table then I would like...

Hello I currently have a button that holds a delete command. When the button is clicked, a MsgBox pops up and ensures that you want to delete (yes and no); Yes deletes, No cancels. Now I need to change it around a bit so that it is more secure. I would like add an 'authorization' code...

Anyone here have any ideas regarding a good idea for an "about form" for my DB??? I will be talking about the purpose of the DB but do not want it to be just text. I think that the MS about Forms SUCK. Any Clues

Hello, I was wondering if there is a way that I can create a 'message' that will appear whent he mouse is scrolled over a button. I have command buttons that launch my reports but would want the user to know what fields are included in each report...therefor, they can put the cursor ontop of a...

just a small question. I have a database that assigns a unique 'audit id' to each entry. the ID is in the form of : DEA-[client prefix]-autonumber. Everything is working fine except the autonumber part. I have gaps in the numeric sequence. Ex: DEA-AAA-1, DEA-AAA-2, DEA-AAA-8, DEA-ABC17...

Hello, I have a little problem and do require help in fixing it. I am only 3% away from finishing the database (due today) but have a little bit of a problem on my hands. here it is: I have a counter on my form that tracks which record is currently being viewed. the code for the counter is...

HELLO :) I have a delete button on my form and I also have a text box that counts the records that I have. One text box shows you "RECORD 1 of 27" which is when viewing all the entries and the other shows you "RECORD 1 of 3 for MICROSOFT" which is more specific. The problem comes in when you...

Hello, I have been reading a lot about splitting databases on this forum. I still have some questions. 1) Will the FE (Front End) still show the tables? 2) Will users still be able to edit the forms, reports, etc.? 3) Will my code be hidden 4) Will all the users have up to date data...

Hello, I have just created a query so that I may base my report on it. The query ties together 4 tables. I only included the fields that will be in my report. I created the report using the wizard and used my new query as the source but it does not want to work. I tried opening the query...

Hello. I have just added some tabs (pages) on one of my forms. The problem is that the background is gray and I cannot seem to change it. How would I go about changing the background colour of each seperate tab(page)???

***this has already been posted on the report formus...i posted it here also due to its relation to forms*** **********************DO NOT GET MAD************************** GOOD MORNING... I currently have a form to launch a set of pre-desinged reports. The main function of the form is that it...

GOOD MORNING... I currently have a form to launch a set of pre-desinged reports. The main function of the form is that it allows the user to sort or filter the data that appears in the report based on their selection (from combo boxes). I currenty have it set up so that the user can choose a...

hi. I would like my users to have the option of selecting a client (cboClient) and then to select a job type (cboMeasureType) and then have a report open up with that information in it. How would I do that. I currenty have the following in a command button but it does not work...

I have created a database but I would like it to be an exe. is this possible? if so, how??? I would like to lock the design and the code for the database. I will be holding about 2000 entries, will this be a problem? thanks

Hi. I was just wondering if it is possible to filter out records in a report using a filter...but here is the trick. Is it possible to filter them EVEN if the coulmn is not included in the report. EX: NAME----ID-----Job type-----Cost----Rebate can I sort them by "JOB APPROVAL" even if that...