Search results

Good afternoon, I searched for answers to this within this forum, and while the problem has been presented previously no one had any responses. So, I'll give it a go and have faith someone can point me in the right direction. I have a replicated database across a server network, so that I can...

Hi, I am creating a data entry program for data being collected from Bangalore, India. My problem is the date formats in India are "DD/MM/YYYY" as opposed to the US format of "MM/DD/YYYY". When I apply the dd/mm/yyyy format to my table design and also to the text box on the form, the format...

Hi, I am trying to populate a field "FN" within a table called "tblFN" with a list of .pdf filenames in the folder "C:\My Documents\Taiwan Cases\" The Access Db name is "TestPopulateCode.mdb" Can anyone assist me in the VBA code to programatically populate that field with the .pdf files from...

I have a survey DB with many forms, several of these have tabs. If for some reason there was a cutoff in the survey I save the form name and question name (which is always the first Ques on any form, or the tabctl value) into FormSE and QueS, respectively, so I can return directly to that spot...

Hi, I have a form with 8 pages (tabs) on it. Each page has a Quit button which populates both a Form name variable and a Question name variable. When a user clicks the quit button the code forces the page name associated with the quit button. I would like to try and catch the same information if...

Hello all, I am creating a survey that has many boolean (Yes/No) check boxes. The problem is, the values we want to use are (0,1) instead of (0,-1 Access defined). First question, can I preset the True/False values differently than what Access has them? That would be my best case scenario...

Hi, I have a delimma and am not sure how to proceed. It falls under the "You want what? When?" category. Basically, I have created an Access program with several (13) related tables and numerous forms. This program mimics an interview we are using for research and has a lot of VBA coding behind...

Hello, I have an Access table and form that has the Date split into three variables one for month, day and year respectively. How can I rejoin these three variables as a singular date? Additionally, can I do it via code. Nothing I sem to do works I have tried to concatenate the three into one...

Subform Quirkiness - Cursor Jumps Hi all! I have an interview program where a respondent gives a free-listing of 'items' with no minimum or no maximum number. Once they have given the list I need to be able to re-rank this list while keeping tabs of the original order with which they were...

Hi, I have several forms with subforms attached for data entry purposes. In a nutshell - this program is for an interview - where we need the respondent to give us a listing (say as to what intices them to join a study, etc.), but for some cognitive research method we need to be able to know the...

Hi, I am trying to develop a database with multiple tables and too many forms. But with that aside, I get about half-way through the program and I reach this one bound form (with two option frames and one text box, all bound), but when I try to update the data and then move to another form...

Good afternoon, I have finished completing the initial version of a database and am now ready to begin the testing phase. When looking at the database properties (Specifically - "Statistics") there is a "Revision Number", which is always blank. I expect some changes and would like to set the...

I am creating a research db and am looking for a shortcut for some data editing. THE SITUATION: I have a series of questions that ask a respondent to check any and all reasons why they believe something. Obviously since it is an "any or all" (there are 8 options) I had to create individual...

Hi, I am createing a simple data entry with VBA in Access2000. My problem is that while in VBA to code somethings behind the scenes, the VBA doesn't pull all of the Objects from my table. e.g., I have a variable called SchDARE. Normally while coding I can type 'Me.' and the object list will drop...

Good Afternoon- I have created a Macro that runs 21 append SQL statements. I want to run this without the Access Msgbox popping up 21 telling me that it will append x-rows to the tables. I want to automatically answer Yes, to all 21 msgboxes. Is there a way to catch these msgboxes and...

I am trying to create a query that ultimately merges two identical databases. I have twenty unique tables and would am trying to create an append query. Is it possible to have one SQL statement where I append each table either all at once or in order? Any thoughts and or examples? Thanks- Scot

I have several Identical Access dbs with Identical 'multiple' tables. All tables use a Primary ID, however the db was created with a 'shell' program and are therefore not related within Access. The shell program creates its own relationships, but the shell program does not have a merge utility...