Forum

Posts

RECENTLY INDEXED PROGRAMMING SOLUTIONS OF Microsoft Access


Referencing a control  

I'm trying to get the value of a textbox on one of my subforms and can't seem to get it properly referenced.I have a main form Main with a tabcontrol having two pages. One page is Timesheets. Timesheets has a subform called Detail_data. On the detail_data... Continue Reading
Views : 40
Monday 22nd of October 2012

Import Table  

Here's another question similar to my previous. Is it possible to have a macro prompt me for the path to a specific file/table I want to import?Thanks,SKK Continue Reading
Views : 51
Monday 22nd of October 2012

Limit character length on unbound control  

How can I limit the length of an unbound control? For instance, I want a text box to only allow up to 3 characters. Continue Reading
Views : 78
Monday 22nd of October 2012

Missing Dao 3.5 Access 2003`  

Hello,when I open a db created in access xp in access 2003 I get this error the first time I open a form: Your... Continue Reading
Views : 49
Monday 22nd of October 2012

Subform Linking Error  

Could someone please help me trouble shoot this error:"The Link MasterFields property setting has produced this error:'A problem occurred while Microsoft Access was communicating with the OLE Server or Active X Control'I get the error when I try and select... Continue Reading
Views : 58
Monday 22nd of October 2012

Emailing Reports  

I am trying to create ta function in an Access Database that will go thru a list of order emails, group the emails, create notes for the specific order (all of which I've created a query for). The final step that I am trying to figure out is actually sending the emails that... Continue Reading
Views : 54
Monday 22nd of October 2012

What code type to study  

If I wanted to take classes to write the code associated with MS Access what would you recommended I take?SQL? Visual Basics? Continue Reading
Views : 60
Monday 22nd of October 2012

SQL Script Error  

I am not sure what I am missing here. The error message I get is "Expected: end of statement" and the blue letters below are highlighted. strSQL = "SELECT tblCases.CustomerID, tblCases.IssueType, tblCases.Status " & _ "FROM tblCases " & _ Continue Reading
Views : 42
Monday 22nd of October 2012

Checking email in database already  

I currently setup a form for a survey which works fine and all the information that is gathered is stored in an access 2000 database.The thing i want to do is to only let the person fill out the form using only 1 email address. So if they try to come back and fill... Continue Reading
Views : 90
Monday 22nd of October 2012

MS Access Macro Problem  

HelloPlease bear with me through this as I am very new to Access and data base in general. I'm hoping some one can assist me with this problem. Continue Reading
Views : 44
Monday 22nd of October 2012

Drop down help  

My database is set up with a sub form showing:Mfg, Model, Serial#, and Type. When I drop down and choose the Mfg, I then go to the next drop down (Model)and the only choices I have are those associated with the Mfg I just selected from the previous drop down. On my... Continue Reading
Views : 90
Monday 22nd of October 2012

List boxe for multiple queries  

Hello,I have a form on which I have placed a list box which will return data from a query via cmd button.Is it possible to use the same listbox to see different queries, using different cmd buttons?I will place multiple button each one of which will... Continue Reading
Views : 67
Monday 22nd of October 2012

Access 2003 Question  

I didn't notice this until yesterday. Created an Access 2003 database - when you open it, it says in "(Access 2000 Format)". At first I thought something had happened to my Office 2003, so I re-installed it. I then created a brand new database - it says, "(Access 2000... Continue Reading
Views : 64
Monday 22nd of October 2012

View monthly report from Access  

My boss wanted me to develop a way for a department to do a monthly report from Access. In the beginning, I set up a login for the user, then the user would input a start date and an end date to retreive the report. However, I just put part of the report up and will need to put... Continue Reading
Views : 75
Monday 22nd of October 2012

Access Query  

I have an Excel Spreadsheet. This spreadsheet has 10 or so worksheets.Duplicates are ok within each worksheet.I need to find duplicates BETWEEN Worksheets.I am concerned with TWO fields.I can import this into Access as One table and... Continue Reading
Views : 48
Monday 22nd of October 2012

ListBox  

I?m new to access so I hope you will have some patience with me. I have a listbox that receives a list of tools from a table. I created a command button that takes the user selected items and stores them in a text box. I copied some code and I understand what it is doing but, I... Continue Reading
Views : 43
Monday 22nd of October 2012

Removing a Field from a form  

I want to remove a input box from a form that is in the service management template . If I try to remove it I get error . Is there some way I can and not get errors . It is the input for the person that is using the form Thxs Steve Continue Reading
Views : 55
Monday 22nd of October 2012

Uploading image name to database  

HiI am trying to simply upload an image to a image folder then take that image name and put it into a access database for retravel at a later date???I can not work out why I am getting the following error and am going cross eyed with it ... can anyone see... Continue Reading
Views : 147
Monday 22nd of October 2012

Counting working days between dates  

I would like to count the number of working days between two dates, NOT the calendar days, if the workers only work Monday thru Thursday. I know we could use the DateDiff function, but HOW do I count excluding Fridays, Saturdays, Sundays? Thank you for your help. ... Continue Reading
Views : 69
Monday 22nd of October 2012

Please Help  

I have a few tables that have all their relations set. What I want to do is create a form that has a drop down box. When the user selects a value in the Drop down box it retieves the specific record and displays the fields of the record in individual text boxes..... Continue Reading
Views : 84
Monday 22nd of October 2012

No longer secured  

I created a DB program for my last job that resided on a stand alone PC. It has the Access generated user level security (so there's a "secured.mdb" file) and can only be opened via the desktop icon. In the past, when I copeid the db to a flash drive, took it home to work on it,... Continue Reading
Views : 49
Monday 22nd of October 2012

Compare 2 tables where NOT EQUAL <>  

It need to compare two tables where the ID Number is not equal. Specifically I need to update new poducts in a table, but only those ID#s that are not already listed. I know how to compare two feilds where they are not equal... i.e.... Continue Reading
Views : 102
Monday 22nd of October 2012

Changing All Table Names  

Hi, I have an Access database that I would like to do a mass Table Name change. Reason is, all tables start with Data. so one table is called Data.Names and I would like it to be called just Names. I can manually do this but there are over 600 tables. Would take... Continue Reading
Views : 46
Monday 22nd of October 2012

Hiding lable in a Report with code  

I have a report that I use with a couple different parameters. I want to be able to change the title of the report depending on the parameter that is chosen.I have different OpenArgs set for each parameter and in the report I want to be able to change the Caption on... Continue Reading
Views : 72
Monday 22nd of October 2012

Query Not Updatable  

I have the following simple query. The query joins the data in two tables and I use it in a bound form. This has worked fine for a couple of years, but today the query is saying it is a non-updatable recordset. This stops users changing any data in the form. I have tried the... Continue Reading
Views : 48
Monday 22nd of October 2012

Dynamic Variables  

On a form which includes a subform -- I have one field (text box A) which is dynamicly populated by the values of 4 combo boxes. Once it is filled and you set focus to the subform, the information from text box A goes to the subform (which is cool and what I need it to do...)... Continue Reading
Views : 46
Monday 22nd of October 2012

Switchboard fails in ADP  

After I upsized by Access app to an ADP, the switchboard refuses to compile. When I click any command button, I get an error saying: Method or Data member not found. The error is at the reference to me.switchboardID in the HandleButtonClick procedure. That field is somehow... Continue Reading
Views : 48
Monday 22nd of October 2012

Open Report Without Menu Bar  

I have several reports that open from a Form. All but one of the reports have menu bars on them...one report does not. I've looked at just about everything and I can't figure out what's causing that. Actually, I really don't need the Menu bar on the Reports, so I would like to... Continue Reading
Views : 49
Monday 22nd of October 2012

Mail Merge Macro  

I am trying to create a mail merge macro that will automatically run when I open up my main document. I am using the RunApp command in Access to open up the main document. This is the code that runs the mail merge and it works fine when I go into Macros and run it. I just want... Continue Reading
Views : 47
Monday 22nd of October 2012

Business Days  

I am trying to calualate the business from an Order Date. The Business Days are Monday thru Friday excluding Holidays. It is for a form that will Highlight (conditional Format) Order over five business days old that have not been completed. Has anyone done this before? ... Continue Reading
Views : 50
Monday 22nd of October 2012