Forum

Posts

RECENTLY INDEXED PROGRAMMING SOLUTIONS OF Microsoft Access


Searching by name  

I need some assistance in searching for a recorded by employee name with the click of a button. There could be more than one record for each employee name so i need a way that once the records are found they can be displayed to the user? ANY help is greatly apprieciated!!!! Continue Reading
Views : 82
Monday 22nd of October 2012

Three dots button  

Where is the button with the three dots located in access so when i go to form desing i could add that button to the form for look up. Continue Reading
Views : 99
Monday 22nd of October 2012

Adding combo box data to a table  

I have an existing FORM called Evaluations where you can select a trainer and a trainee from two different combo boxes. Once a name is selected from both of the combo boxes I click on an assign button and I want it to record those two names selected into my evaluations... Continue Reading
Views : 250
Monday 22nd of October 2012

Reporting error  

I am currently trying to do a total of several fields in a report. The fields in the report do contain null values. I have been trying to write this through VB but I am getting the error that I can not seen to get around. The thing I am... Continue Reading
Views : 56
Monday 22nd of October 2012

Using the FindFirst Method with DAO  

I am writing an event procedure to check to see if a particular Project number exist in a recordset. I am trying to use the findfirst method and are having some problems. Here is my code.Private Sub Command3_Click()Dim db As DAO.DatabaseDim rs As... Continue Reading
Views : 90
Monday 22nd of October 2012

auto number  

i have 47 records in a table that were numbered 1-47 with auto number. i arranged the records in order of date increasing, and now, the auto numbers are all jumbled up. I want to have autonumber re-number the table 1-47 with 1 being the earliest date and 47 being the latest. is... Continue Reading
Views : 58
Monday 22nd of October 2012

Copy and paste  

To speed up my input I copy a record and paste it. Only trouble is that I have one field in the table that is dependant on the parent table. [The customers email address which I populate with a query/combo box. There could be many, depending who the order was for.] Continue Reading
Views : 55
Monday 22nd of October 2012

Users unable to access new forms/tables  

I enabled security on an .mdb which included several users that are in the Full Data Users group. After I did this I needed to add a new form to the application, so I logged into the application and added it. However, though the admin group and the Full Permissions group can... Continue Reading
Views : 122
Monday 22nd of October 2012

Linking Tables to Remote DB  

Hey all,I'm trying to set up a database in Access which, in the end, I'd like to be a copy of the master DB, but with all the tables linked. the goal is so that it is smaller in size and less volatile (since it detaches the users from the original db).The... Continue Reading
Views : 50
Monday 22nd of October 2012

Getting post between rank x and rank y  

Hi,I've got a table with football players, each player has a name,id and a value. The value gets updated everytime the playerhas played a match.I don't have a rank field, and lets assume it's not possible toadd it.I'd like to... Continue Reading
Views : 63
Monday 22nd of October 2012

Problem displaying JPEG images stored in Access DB  

It may seem a really silly question but is there any restrictions as to the file types that can be stored in an Access DB.I havent used Access in a while, but have been asked by a friend to create a simple DB holding info about cars he is selling, he only wants to... Continue Reading
Views : 92
Monday 22nd of October 2012

How add feild size and null constraint check to this vba  

Hi guys. I have a program that i want to add feild size and null constraint check on it and make it work on accesss 2000 . I be happy if some one help me modify this code so it generate Acess sql statements so that i be able to paste it in sql window of acces 2000 and it... Continue Reading
Views : 61
Monday 22nd of October 2012

Help with date search  

Help! Right now in my database the dates are displayed as yyyymmdd, and i'd like to be able to pull all records in a month (to send birthday cards). How would I do this? Thanks. Continue Reading
Views : 100
Monday 22nd of October 2012

problem with security server  

I've placed my database on our office server. The database has a security file attached to it and must be launched via a shortcut. I've copied the shortcut on to the desktop of another machine, and when I launch the short cut, it prompts for the password and all... Continue Reading
Views : 82
Monday 22nd of October 2012

Check if Filed exists in Table and Add if it does not  

I need to check if a field exists in an access DB table. If it does not I need to add it. I am using ASP with VB. I am reletively savy but wtill a newbie. I am looking for the BDayAlerted Field in the... Continue Reading
Views : 61
Monday 22nd of October 2012

Access -vb help  

Dim con As ADODB.ConnectionDim rs As ADODB.RecordsetDim db As DatabasePrivate Sub cboiden_Click()Dim q, r As Stringr = "select date from instbl where identity='" + cboiden.Text + "'"txtdate.Text = rEnd SubPrivate Sub... Continue Reading
Views : 80
Monday 22nd of October 2012

append data  

how do you add data to an existing field rather than replacing it? thanks (is this the right place for SQL?) Continue Reading
Views : 55
Monday 22nd of October 2012

Is there a way to do....  

Is there a way that I can read in records from one table looking for a record in a second table with the same key, and if I get a "hit" or match, that I update a field in the first table? Continue Reading
Views : 111
Monday 22nd of October 2012

Table Design in Access  

Hi,I have made a table(picks) with fieldsPickID(primary AN)UsernameWeeknumberwinninningteampointvalueThe data is entered through a web based(asp) form. It is for a football pool. The problem i am having is trying to figure out... Continue Reading
Views : 64
Monday 22nd of October 2012

relationship problems  

I have two tables with a 1-many relationship.fld1_1 of tbl1 is an autonumber field and also its primary key.fld2_5 of tbl2 is related to fld1_1. fld2_5 is a number data type. fld2_5 is not a required value for a record in tbl2, i.e. it may or may not have... Continue Reading
Views : 89
Monday 22nd of October 2012

Text Boxes  

I have two applications that I am developing,App1 = Standard data collection form with numberous text boxes, drop downs etcApp2 = Access database that I set up to read the NMEA String coming from a GPS Unit. I then parse it up and write the values to... Continue Reading
Views : 54
Monday 22nd of October 2012

Max amount fields in a table  

What is the maximum amount of fields/columns a table can hold in access 2003?And what do you do if you have a form and its record source is a table that has run out of fields/columns?If I remember right in access 97 it was 256 or 257 fields/columns was the... Continue Reading
Views : 149
Monday 22nd of October 2012

What is runtime error 7225  

As the topic indicates: what is runtime error 7225?Thanx for your help Continue Reading
Views : 64
Monday 22nd of October 2012

Parameter Window Help  

Is there a way to have unlimited parameter boxes to pop up when a query is ran?Thanks Continue Reading
Views : 61
Monday 22nd of October 2012

Date/Time  

hello again In my db, i have tblCenterName.Appointment with the format mm/dd/yy hh:nn and the input mask as 99/99/00 99:00;;_ I want the user to only be able to... Continue Reading
Views : 5
Monday 22nd of October 2012

Cant open my files  

I have create a page in Micro Access and save it. But when I open it, it says sth like this"db3.mdb cant be opened because u must restart the application for the new security" Continue Reading
Views : 80
Monday 22nd of October 2012

Access Question  

I have 2 tables, each with 3 fields DocNum, ReferralNum, and LocationNum in each. What I need to do is match DocNum and ReferralNum in Table 1 to a record in table 2 that matches. Then if there is a match, I need to see if both the LocationNum are equal. If they are not, I... Continue Reading
Views : 52
Monday 22nd of October 2012

Problem with code on OCX Calendar  

I've copied the code for an OCX Calendar on one of my forms to another form used for the exact same purpose. Everything is exactly the same and I keep getting the following error every time I click on the calendar:RT Error 91:"Object variable or With block variable... Continue Reading
Views : 78
Monday 22nd of October 2012

"Enter papameter value" error  

I am trying to link a text box on a form to a text box on a report and I am getting this error can someone help me please.Its just some text I put on a form text box that will copy over to every report...Thanks Bob Continue Reading
Views : 62
Monday 22nd of October 2012

Select and Print an Excel Spreadsheet from ListBox  

Hello,Propably I am asking too much but know that Access and VBA can almost do anything.Is it possible to add a list box on a form to list the spreasheet in a excel file and by clicking on the select record make a print only of that specific spreadsheet? Continue Reading
Views : 62
Monday 22nd of October 2012