Microsoft Access / VBA Forum

Thanks in Advance! ... I have two textboxes: 1 is visible (and gets its value based on the invisible textbox and displays either "Male" or "Female", and needs to display either male of female based on the value that comes up in the tables record as "M" or "F". I tried: =Iff((!)="M","Male","Female") 'the is form, is the textbox name

Hey guys, I have accidentally deleted the switchboard of the database that I had created. The switchboard form doesn't appear when I click on the Forms section in Access. But heres the deal, when I click the Tools>Database Utilities> Switchboard Manager, the contents of the switch board show up with all the changes . It also allows me to make the...

Hi all, I am new to access and I face the following "issue": I would like to create a database, to which users can upload files (=pdf, doc, xls...). The files shall be stored locally on a server. The database needs to be accessed via Access form (no html, asp,...) as we don't have an internal web server running. I would like to create a...

I wonder what I'm missing? I really feel like a retard because I've been screwing with some code for a very long time. I just must be missing something very simple. In the following example, I've stripped away everything that doesn't cause the error to make my question a little simpler. Here's the problem in its simplest form inside a...

Hello everyone, I am new to access, coming over from FMP5.0. I am working with a table#1. In this table I have two fields (among others). Field one is "Card Name" field two is "Card Number". In table#2 is the list of Card names with their corresponding card numbers. What I need is when my user selects the "Card Name" from list in Table#1...

Multi-Lingual Access Databases Summary. I have been asked many times to produce databases that can be used with different languages, such as English, French, Portuguese, German, Norwegian etc. I have developed a system for this which I will share with you now. This system will allow all your forms, reports, in-code messages etc to be...

I'm moving a database from an Access backend to a SQL Server 2005 backend. What I need to do is to append the number of records that get pulled in from a table and increment the voucherNumber field to the next available one. The code below was originally written in DAO. Dim RecordCount As Integer Dim strSQL As String Dim db As...

HI; I feel like a fool..I put CUTE FTP in my last request for help --it should have been CUTE PDF! I have FTP on my mind because I have been working on a web based application, and somehow my brain got stuck on it..sorry! Hi: I need some help writing code that will "print" a report using Cute PDF.

I have a buch of fields that I'd like to update on a form at once, but I'm having a problem with allowing fields to be blank. If any of the fields in the SQL statement are blank, the update doesn't work. The way I see it, for example, SET ContactLastName='' (two single quotes) is somehow invalidating the update, although I can't seem to...

I have an application that does some data manipulation of some tables to format a table for a report. 1. First I open the table that gives me the parameters for some later queries strSQL = "SELECT DISTINCT tblMain.MeasureID, MeasureName, CountryName, AxisID FROM tblMain;" Set rstMeasure = CurrentDb.OpenRecordset(strSQL) With rstMeasure

I have a list of towns in tblTownData, and a list of people's names in tblNames. During a year, there are multiple events where more names are added in tblNames, for a particular town. ie: TOWNID EVENTID NAME 1 1 John Doe 1 1 Jane Doe 1 2 Bell E. Dancer 1 2 Frank N. Furter

Hi guys Thank you for all your previous answers. My new question is as follows: how do I create a folder/file browser in access 2003. That is, I would like the user to locate several files (the back-end, logo, etc...) and save the path. Cheers Nic.

Okay I know how to upper case the first word. However, how do I make it so first letter of each word in the same field is capitalized? Thxs.

I have a db with about 75 forms. I am trying to tidy it up and would like to print out a list of all the forms to help in the process. I have looked at the HELP section for VBA and found some code: Sub AllForms() Dim obj As AccessObject, dbs As Object Set dbs = Application.CurrentProject ' Search for open AccessObject objects in AllForms...

What is the easiest way to write SQL that Access understands to achieve simple standard SQL query below? Thanks in Advance, Phil SELECT

I have a calculated field in a form using this expression typed in the control source box =+ Since I cant bind this field to a table field I would like to transfer the value returned by this expression to a field in a table. Does anyone know how to do this?

tblExpDetails has various fields including two Yes/No fields and one Category field. frmExpDetails is based on this table. I would like to add some restrictions wWhen an end user is using frmExpDetails to add data: 1. Restrict selection of one check box at a time. i.e., if one check box is selected the end user will not be able to check...

Hi all, I've got a table that I've imported and it has junk at the top of the table, so after import I run a delete query to remove the junk lines then I'm left with the field names I want for the table at the top of the table but the field names currently are 'field1' etc, so how do I rename the field names to the fields on the top row of...

Im currently having difficulty trying to write an SQL query in Access which will add two columns together to calculate a totals column. For example... I was hoping to get the below resultset from my query, e.g. "select name, hours, overtime, hours+overtime as total" Name Hours Overtime Total...

I'm trying to log error messages and sometimes (no telling when or where) the message contains a string with double quotes. Is there a way get the query to insert the string with the double quotes? Do I need to use code to scrub each string and remove or escape the double quotes before using it in a query? The error I get is this: ...

Hello all, The noob is back again. I've spent all day trying to figure out how to code an edit button to update a record in a table. I have made progress, but now I am getting some kind of "locking violation". When I tell the query to run despite the locking violation, it doesn't update the record, it just adds the record onto the end. Also,...

Hi experts, Could you please help me with this situation? I'm using Access 2003 and I have a form with combo box containing lists of customer orders and status. What I need help on is when users choose customer order with status "C" then the font in the combo box for this customer order is red, else will remain black. How can I do this? I...

I'm trying to set the width of a form so that it's only about 3 inches wide on the screen, but it keeps maximizing itself. If the calling form is maximized it immediately goes to maximized. I'd like to set the size of the form in either VBA or in the properties window and have it stay that way whenever the form is called.

Hi All. How can i put a zero decimal for my currency into my format statement, == & ", for " & & " days. Cost " & Format(,"Currency") which is the data source for a textbox on a report

I need the syntax for limiting query results to either even or odd numbers, depending on certain conditions. Any help is appreciated. Thanks, ang