Forms :: Create A New Blank Database And Import Everything?
Nov 22, 2013
I have comboboxes on forms that i have entered the values for the drop down list in.They are on a form with textboxes and go through a one to many relationship via an intermediate table.I deleted one value from the list as it was no longer required and i also deleted the records that used to use that name.
When i looked at the list, the value is still there?I tried inserting a new Combo Box - the same?Will it clear if i create a new blank Database and import everything?
View Replies
ADVERTISEMENT
Apr 10, 2013
I have a split database consisting of an ACCDB backend helf on a shared drive, and a local ACCDR frontend distributed through email. I recently distributed a copy of the ACCDR to a user, and she says that the main menu opens fine, but when she clicks a button to open a form, the form opens but is completely blank. I've googled some possible causes for this (e.g. on Allen Brown's website) and none seem to be relevant, or would explain why this started happening all of a sudden. I can't reproduce this bug at all.
View 8 Replies
View Related
Mar 26, 2013
I have updated my copy of a database which included updates to a number of forms. I now want to import those changes into the proper database, so I used the Import function. I didnt get any errors when I imported everything, but the forms do not work as they did in my copy of the database.
One of the forms that dont work comprises of a number of drop down boxes, I have updated these so that the user has a filtered selection, to do this I put an SQL function in the Row Source property. This SQL function has been copied over correctly in the imported form, in fact when I go into the form in design view to check this fact then revert it back to normal view (after having not changed anything) it then works and all the other drop down boxes that didnt work on that form now work! How can viewing a form in design view and not changing anything make it now work?
So I could go into each form in the design view, check the Row Source property, then revert back to normal view and it would solve the problem of my forms not working, but, this database that I am importing the forms into is the back end of a split database and the first thing that the front end of the database does is import the changed objects into its database but the forms dont work.I have made changes in this way before and not had any problems before.
View 2 Replies
View Related
Nov 6, 2004
I am wanting to create a command button that will let me chose the .csv file I want, and then have it create a table automatically.
Thanks In Advance
View 3 Replies
View Related
Nov 19, 2014
I wanna create a button in form which can allow me to import database and when i select my file , i can select just the variable that i need .
View 2 Replies
View Related
Sep 15, 2005
Hi,
Im trying to import a spreadsheet from Excel. I use the wizard and I get the sheet imported. The only problem is that I get additional blank fields in my table in Access. How can I make sure that this does not happen? I want to keep on importing into the same table, so these useless empty fields keep on accumulating.
Any help?
Thanx,
Stacey
View 2 Replies
View Related
Feb 2, 2014
I have 2 tables and I can create 2 forms from them but when I try to use both tables to create one form the form is blank.
View 2 Replies
View Related
Jul 5, 2006
how do you create a blank mdb file with a specfic name?
I tried the following but it does not work
path = "N:Data est 061606_data.mdb"
CreateObject path
View 1 Replies
View Related
May 20, 2015
I have a fully functioning login screen with a combo box for name and a password box. It also has an option to create a new user or exit the database. On my main form I want the employees to have to log out of the database as opposed to close it out. How would I go about this? Also I need tracking login and logout times for each employee.
View 3 Replies
View Related
Dec 1, 2013
I am new to MS Access! I have design a database and a form to record the information of customer feedback.
The first thing I want is to search the record from the whole database. Secondly I want to print that searched record. And finally I want to make a Form Reset Button.
I have made a "Clear" button but it is not working correctly and removes the record from the database after saving.
I have attached the database!
View 4 Replies
View Related
May 22, 2013
I have made a very simple log on form that requires the user to type in a user name and password. The user name and passwords are stored in a table. New users are added to this table to allow access to the database.
Is there a way I can add a counter to see how many times a particular user has logged onto the database?
Is there a way to make the password expire every 365 days requiring the user to reactivate their account and log in details.
View 2 Replies
View Related
Mar 19, 2015
I have a very unusual situation where I need the name of a field in an Access table to end with a blank (i.e. space). I tried doing it trivially while in Design View but no dice. I tried it through some SQL along the lines of the following pseudo code
Select [old table].[Address] as [Address2 ], [old table].*
Into [new table]
From [old table]
but the new field's name "Address2 " lost the final space.A third try was through some syntax for an Alter Table statement to add or modify a field. It didn't pan out.
View 2 Replies
View Related
Apr 4, 2013
I am trying to create a navigation form on a split database with front end and back end.But Access is not letting me drag forms or reports into the navigation form. Why?
View 1 Replies
View Related
Apr 13, 2011
Is there a way to create a relationship so when a new record is entered into the main table it automatically creates a new row/record in the related table with just the foreign key entered?
View 11 Replies
View Related
Mar 31, 2006
Hello all,
Is there a way to create an import specification automatically, such as via vba? I'm trying to create a form that will allow a user to import a list of fields that could appear on a table. This field can change though depending on what kind of list they are trying to import. Does anyone know a way?
Thanks!
Vassago
View 7 Replies
View Related
Mar 25, 2013
When entering information into a blank form, I would like to be able to continue entering information to another additional blank form after my last entry. Is there a way to continue to a blank form after entering information into the previous blank form? I would just like to continue without having to close the entire form and then reopening another form.
View 7 Replies
View Related
Dec 25, 2005
I'm new to Access and VBA, for the record. What I need to do is copy a SQL database (table structures and records) and save it as a local Access database, so that the user can query and make any changes on the local file without editting the SQL database.
Looking around, it seems like the best option would be to use the TransferDatabase method with the acImport option. Does this sound reasonable, or can someone with more experience suggest a better way to go about it? Thanks.
View 3 Replies
View Related
May 6, 2015
I have written an invoicing module for my program and some users in the office are dirtying a record and then leaving the module without completing the invoice. (This leaves behind an almost blank record with a period in one field or a space, etc). When someone else starts an invoice from another workstation it skips this almost blank invoice and starts a new one, skipping the almost blank one. Is there a way to check for these orphans automatically before using another invoice number. This happens once or twice a day so it is of concern to my bookkeeper who checks the sequence of invoices to make sure none are missing before posting them to the accounting program.
View 4 Replies
View Related
May 13, 2014
I am trying to create a form to enter data in a table. I would like to make it pull in info from a switchboard. If the record already exists I would like it to find it and allow me to edit the info. If the record doesn't exist I would like to be able to add a new record with the data input. What is the best way to accomplish this?
View 1 Replies
View Related
Aug 28, 2013
I am testing the security of my DB X on Acccess 2007. I could create a new database Y and linked to the database X. Unfortunately i could change the records on the tables. I don't want other DB that make connections to my DB to change my tables!
View 1 Replies
View Related
Aug 15, 2005
Not sure where to post this question, so I put it in the general section,
I have an old db that i would like to import into a new be db of a newer version i wrote of this db. Is there any way something like an append query will add the records from one database to another?
or do i have to import then append then delete?
I have read several posts on this forum reference importing but all of them are from excel spreadsheets. Can this even be done??
Ricky
View 4 Replies
View Related
Nov 22, 2013
I am working with an inherited database. When this database was created, a large amount of data was imported. Over the course of time, I have added additional fields for tracking information. One such field is "Date Started."
Unfortunately, there are almost 500 records without this information and that is skewing some report results.
I would like to do is insert the date of 9/9/1999 into all records that have no data in this field. (This date is well before the creation of the database and would serve to indicate old records, whether or not they are still active.) Copy and pasting isn't working, and I can't do a find and replace, since there's nothing to find.
View 1 Replies
View Related
May 31, 2006
I have two databases. One is 'live', one is for development. Once i get something working in the latter, I import it into the former. This has been working fine for just over two months.
Today, however, i'm trying to import a form and get one of the following messages:
"The search key was not found in any Record"
"No current record"
I'm unable to import the form.
Any ideas what could be causing this?
View 2 Replies
View Related
Nov 9, 2006
I am trying to help a person that has a 1980s DOS database called "SMART". The program "smart" will output the database in a format that Access should be able to read, but it can't read the full file.
Any obvious ideas about what might be the problem?
View 2 Replies
View Related
Nov 24, 2004
Hi All,
I have a split database. One of the processes I've
created, copies a new table from a previously created
blank table. It then imports data from an Excel spreadsheet
into the newly created table. My problem is that now when
the import occurs, the data is getting imported into both
the new table as well as the blank table. For some reason,
this only occcurs after the database is split. I've tested on
a backup copy that is not split and everything works fine.
Any ideas please?
Thanks,
View 2 Replies
View Related
Mar 13, 2014
I want my access database to store information about "tests" and "products" that are in each "test". So "tests" is the "one" and "products" is the "many" (each test has many products).My client needs to routinely send me lists of tests and the products that are in each test. I then need to put this information in to my database
I don't want to type out the information they send me, instead I want to devise a simple form for them to complete and email to me (perhaps in excel) that they populate, and I then import/paste in to my database.How should the excel form be structured so that it is both easy for my client to populate and easy for me to import/paste in to my database. e.g. importing lots of test and product information, rather than type it in. Bearing in mind the 1:M structure.
View 3 Replies
View Related