Ok, please bear with me, I am new to MS Access and am building a database for vendors. I have a question: I have a form already created and my boss wants a...
Welcome to MS Access. It is a great application. Go to design view of your form and then make sure the Wizard is set to on. the wizard depending on which...
Jim, The form is already created. I need to know how to create the look-up on a field that has already been created. I followed your instructions, but it...
Sorry, maybe I did not break down the process enough. open your form that you want to add the drop down box. Now with the form open you should right click the...
Hello All, MS Access 2007 I have been working on this for months off and on. I have found many examples, videos and help but nothing really does what I need....
Dear All, Using Access 2003/2007 does any one have any experience in building right to left menus on the form itself, maybe by using an activeX tool or any...
Hi I am fairly new to access. I did build some old DB back in 97. I can't seem to find a template that will work for what I need and I am on a deadline. I...
You should be able to import your spreadsheet as a table in your new database or link to the existing spreadsheet either way you will be able to run queries on...
Hello All, MS Access 2007 I am trying to get a conditional formatting to work. I have a field named [Last Date Worked] and I am trying to get the field to...
Hi, I'm using Access 2003. In my db I have a report using a control in a form. The control is in short day format and has the default value "Now()". When I...
Ruhi, If you field use for criteria for report , shuld be convert again to real Date. for criteria use #date# or date before format. Regard's Heri Setyono ... ...
Sent a client a MDB copy of the MS Access program built for them. The database has a refresh process to update a set of core tables from another system...
I have a table that holds employee evaluation data. I am being asked to give managers an option to use excel to conduct the evaluation. This means I will have...
Heri, I couldnt solved the problem with your way but solved it by writing "mycntrl=date" at onload event of the form. Thanks for your nice reply. Ruhi...
Hello All, I have an interesting problem. My boss tries to open a specific database on her computer and she gets a 2501 error. It is only this one database and...
Paths and user permissions? ... -- _______________________________ Daniel de Oliveira Mota Mestrando NCA&T (Mastering at NCA&T) Management Science -...
Hello All, I have a question about the nodata cancel procedure. I have the following code in the on no data event Private Sub Report_NoData(Cancel As Integer) ...
My 1st version of Access was 1.0 upgraded to 2.0, (both on floppies) My newest computer does not have a floppy and I'm not sure Access 2.0 will even run on XP....
I have an upgrade CD for Access 97 but it needs to see proof that I have an old version in order to load. I have versions 1.0 & 2.0 but no floppy drive in the...
I am afraid I only know enough about Access to be dangerous, but have a question about a replicated database. How would be the best way to limit access to a...
OK! I used the USB floppy drive I bought and put in the #1 floppy of my version 2.0 of Access. Then I ran the upgrade CD. I had to also download & run a new...
I have an idea that I am not sure how to begin developing. I have a spreadsheet that has the pay period ending date, Sick and Vacation column headers. at the...
Jim Assuming it's an access table i suggest you include a date field which should be populated with the current date when importing the data from the...
This is an update to my dilmena... The program was created using MSO2007 (MS Ofice) and down versioned to MSO2003... had some issues so I installed MSA2003 and...
Hi, Well, there are few custom settings like date format which can make this happen. The date format is taken based on what is set in the control panel and...
Hi all. I have a form from which I click a button to import data into a new table. then I want to click another button to cause that data to be appended to...
Hello, I remember someone on the list who once made a perfect and pedagogic explanation of the difference between a database (Access) and a spread sheet...
I live in the Northern New Jersey area, and have done database developing. However I am working on a database for my music hymnals and songs. I have two tables...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
