Well, today I had a problem with my main access db. It stopped letting me create MDE files, and my usual trick of decompiling it didn't work. I eventually got it working by importing everything into a blank database and setting the startup form and references again. However when I did this, I noticed a very big difference in file sizes. My old MDB file was 14mb, while the new one was about 5mb.
Just wondering if anybody else has come across anything like this before? Everything seems to be working fine and transferred over corrrectly, but such a huge difference worries me slightly.
I have an Access Database of around 8MB. However, after a day's use, this file size increases to around 110MB. If I run a Compact and Repair, the file returns to it's usual size. The first time I noticed this, the file had reached a size of 2GB which is a bit alarming. The file does get used but only appending around 50 records a day and making some amendments. What could be causing this increase?
Last night whilst working on my database, I made some changes to the layout of the switchboard. Closed the form and then closed access. I tried to reopen the database to see the changes I made. But instead I get the following screen.
Once this has happened Access creates but does not delete the lock file. Simply deleting the lock file does nothing. It also creates a backup of the database which also does not open, and also leaves a lock file.
Anyone know of a tool I can use to check the validity of the database, or be able to drag as much data out of it as possible. I am away from my backups and really need to get this going.
Probably important to know the database has a .mdb extension and the lock file .ldb. and I use Access 2007.
The app works as it happily opens other databases.
I have a search form (continuous) which filters results from the main table. I can then double click on one of the filtered results to open a new form (single) showing all the fields for that entry. Fine so far.
My question - There are ten different types of operation that can be displayed, all with slightly different relevant fields.
Which of these methods is more efficient: 1. Make ten custom made forms (the correct one displayed depending on the selected operation). - Easy to do but needs ten forms.
or
2. Have one form with all the fields added (only the correct fields made visible by code). - Complicated code.
I am trying to form a join between two separate databases. Database 1 has a column (Gene_Name2) that consists of common names of human genes. In this database there is only one name for each gene per field. The other Database 2 has a column (Gene_Name2) that has various names for the same gene in each field. Most genes have been given different names over time. I want to join the databases into a separate query database so that all of the information in Database 1 is retained and only when the name in Database 1 matches one of the names in Database 2 does the row of information get tacked on to the query database. The problem is that in a normal query the text in both Gene_Name columns do not match and the query returns no matches. I have tried Instr and like criteria statements with no luck.
I have database that is linked to an asp style website. In my Products table, I have a field for Product_Description. Unfortunately the descriptions for the products that I have are very lengthy, some 10 sentences and above. And as access only allows for field sizes of 255 characters max, I can barely fit 1-2 sentences here.
I was wondering whether there is a way of getting a much bigger field size at all?
How can I control the size of my form. I would like some of my form with my program to open small, since they are small forms, and some large because they are the whole size of the forms. I hope I have explained this enough for someone to help.Thanks in advance.
Hi, I am a new member, who has been reading these postings for several weeks, hoping for a few quick answers, but no luck.
I have several issues on form size.
The first is that some of my forms open OK, but they change the form size of the form that opened them. My main form is maximized. When I open a child form, not maximized, the main form, and the open Access windows, such as the DataBase form and any open Tables, Queries, Reports, etc all become non-maximized.
The main form has the dimensions of the last-opened form .mde files, which leads me to believe that there is some Access option that crosses project or database lines. I cannot find it.
If I maximize the main form with the child form open, Access maximizes the child form also. If any form is open in Design View, the Properties window may be on top of everything. As the controls I need are seldom visible in these small windows, I spend much effort resizing windows.
What do I need to do to have a maximized "Switchboard" and smaller child windows/Forms???
I have a multiuser database back end with approximately 25 tables. The file size for the back end has recently jumped from approx. 50mb to 270mb, but I do not know where the data causing this increase is placed. Is it possible to measure the file space usage (in mb) that each table contributes so that I can determine the source of the increase.
How can i make all my forums fill my screen? so dont have to recreate them? so they are not just tiny boxes. as originaly designed? I looked in hope that there maybe have been something in the startup drop drop down, but i was't so luck. also tried to select whole forum and group and name the whole thing bigger by dragging the resize command. but this just messed the whole forums up so i did't save changes.
i am developing a clothing order management database.
I have so far got [order details], [products], [product details] entities. This is so that products with the same model code can have a selection of colours and sizes which are held in the product details table.
I followed this website which was very helpful: http://www.princeton.edu/~rcurtis/ul...database2.html
The question is now: each size and colour will have a different stock quantity. How do i model this, for example, so when a Small Red t-shirt is added, the small red t-shirts quantity decreases rather than the overall quantity for the model.
After much work and help from a lot of competent ppl on this forum i have finally been able to get my dB together. Now i have a problem though which i can't solve. Problem is this: I open a form, lets call it MENU. From this you open a second form called NewEmployee. In this new form you insert new data about the employee(s) and then insert them in the dB. So far so good, but when you do a print about the employee, the procedure is this: A special form is opened (PrintOutForm), its fields are filled with data from the NewEmployee, it is printed and then closed. Problem with this is that the MENU form is now not-maximized :) Which it was when you opened the dB.
Is this something any of you guys have encountered before?
I browsed a lot of posts related to fonts, and pored over my "Mastering Access 2000" and "Access 2000 Power Programming" books, but I couldn't find answers to my specific questions.
I have many years of experience with Access, but I've only recently become interested in making my forms look nice on a variety of user PC configurations. Now, like many others, I sometimes spend too much time formatting a form so it looks really nice on my PC, only to find formatting problems on the user's PC. For example, a label using Arial Rounded MT Bold looks great on my PC but is cut off on the user's PC. Similarly, Tahoma on buttons looks nice on my PC but looks bigger and bolder on the user's PC.
At first I thought this was probably a font problem. But then I realized that even with the same screen resolution, the forms themselves (not just the fonts) appeared bigger on the user's PC. Some forms didn't even fit inside a maximized Access window, whereas they certainly did on my PC - again, this is with the same screen resolution. So now I don't know if it's a font problem, some other problem, or perhaps multiple problems.
Which leads to my questions:
(1) If I set the size of a form on my PC, and the screen resolution is the same on my PC and the user's PC, then why does my form show up relatively bigger on some users' PCs? How can one control the look of a form if the form properties are not applied identically on different PCs?
(2) Why do all the fonts look bigger and fatter / bolder on some users' PCs?
(3) Is there a user-configurable Windows setting that overrides the font size settings I assign to controls?
(4) How can I determine in code if specific fonts are supported (if this is a necessary step)?
(5) What is the industry best practice for managing font selection, allowing for the possibility that the desired fonts may not be supported?
I have written a database application in Access 2003 for my company. I am going to deploy it with Terminal services on a Windows 2000 Server. I went to my server room to logon and test and found that 90% of the screens I designed had print and close command buttons that were off the screen. I developed the application on a 19" plat panel display with 1280 X 1024 res. The server room has a 17" Non-flat panel with 1024 X 768 res. I am assuming this is the culprit. Is there a way to make the application a "ONE SIZE FITS ALL" solution. Im sure writing a different version for every possible resolution is not how it is done. Any ideas would be deeply appreciated
Is there a means of making an application grow/shrink to accommodate different screen sizes? eg. not all users of a distributed application will necessarily have the same screen size.
Using Access 2010, I have a subform in datasheet view and I want to set the font size to 10pt. Setting font sizes for datasheet fields in the Format tab does not change the font size displayed.
I understand that the font size can be set using VBA (for example: Me.DatasheetFontHeight=10). Where do I put this code for it to work in a) a single datasheet b) all datasheets in the db?
I'm trying to make a database table for a sneaker inventory display/controller, it will be displayed on website using Dreamweaver to pull out the records. I can't figure out how to have a "size" entry in the table, let me explain:
Here is the problem, I need a "Size" field in there, but a sneaker will have multiple sizes (i.e. 6-11) and each size will have different quantities. Is it possible to incorporate a "size" field in my current table? or should I re-do my table in another way? How?
I recently upgraded a DB from 2003 to 2013 and ran into the following problem.
I have a button that opens a file dialog box and allows the user to upload a file to a predetermined location (and store the address as a hyperlink). I borrowed this code from someone else on here and modified it slightly.
In any case, the button still works, but now when it opens it doesn't have an option for "All files" under file types. So I can upload MS Office files, text files, etc., but not PDF files which are by far the most common types my users upload.
Private Sub Command35_Click() Dim dd As Integer Dim fileDump As FileDialog Set fileDump = Application.FileDialog(msoFileDialogOpen) dd = fileDump.Show Dim Yourroute As String Dim yourrouteName Yourroute = fileDump.SelectedItems(1) yourrouteName = StrReverse(Yourroute) yourrouteName = StrReverse(Mid(yourrouteName, 1, InStr(yourrouteName, "") - 1)) FileCopy Yourroute, "us170fp00dataWBO_Tool_RoomDrawings" & yourrouteName Me.Drawing_Link = yourrouteName & " # us170fp00dataWBO_Tool_RoomDrawings" & yourrouteName End Sub
I often create contract using mail merge. I have an access file that I want to use as data source for word file. But it does not automatically.
Please download the attached file !
If there are 1 customer and 1 property, I do not need to do anything. Conversely, if there are many customers and many properties, I take time to manipulate.
Firstly, I open the word file. I have to copy and paste paragraphs that I want. Highlight of the original paragraphs is blue.
Secondly, I click 'Insert Word Field' -> select 'Next Record'.
In short, I wish to use VBA in access file to automatically perform the steps that I have outlined.
I've got the forms and queries in one .accdb file and my tables in a separate .accdb file. The forms file links to the tables in the tables file. The tables file resides in a folder called simply enough C:acc_tables and thats where i browsed to (obviously) when i set up the linkage.
One of the users does not wish (for whatever goddamn reason) to create a C:acc_tables file to stick the tables file in , and wants the tables file in some other folder.. Unfortunately this user does not have the skills to delete the existing links and re-link to the tables file after putting it in the folder he wants.
Where in the file that holds the forms and and queries do i find the path setting to the tables linked file? Can it be changed without deleting links and then re-linking?
I would like to automate something presently done on a one-by-one basis. Here: a number of text files(containing data) are to be exported into an MS Excel file, with each text file to occupy a different worksheet. Presently, the idea is to use the Data/import external data/import data feature of MS Excel for importing the text files one-by-one into newly created worksheets(within the same workbook).
I would appreciate some advice on how to go about creating a useful MS Access application to achieve the above. I have checked the available Macros in MS Access, but I could not find one to suit my purpose. can anyone pls assist, on how I can get started?
Question: Is it possible, using VBA, to determine the actual Excel file type without opening the file?
I receive data files from other departments. Seems like every time someone changes their download structure, I end up with file types that do not match the download extension (example: xlm file with a xls extension). The files can't even be opened because of this. I think I can fix it if I could figure out how to determine what the file type really is.
i had a database that allowed me from a form to store a file location for a record on a form, so i any time i could access the record, and then open the file, usually a pdf, it wasnt stored as a hyperlink, but as long text
i made the mistake of not copying the files for safe keeping when i got a permanent position..i am now back self employed, i need to recreate the database.
I recently upgraded a DB from 2003 to 2013 and ran into the following problem.
I have a button that opens a file dialog box and allows the user to upload a file to a predetermined location (and store the address as a hyperlink). I borrowed this code from someone else on here and modified it slightly.
In any case, the button still works, but now when it opens it doesn't have an option for "All files" under file types. So I can upload MS Office files, text files, etc., but not PDF files which are by far the most common types my users upload.
Here's my code and a screenshot is attached.
Private Sub Command35_Click() Dim dd As Integer Dim fileDump As FileDialog Set fileDump = Application.FileDialog(msoFileDialogOpen) dd = fileDump.Show
I am using the following code to select files using Microsoft Office's file dialog:
Public Function fTestFilePicker() As String Dim fdFileSelection As Office.FileDialog, lstrFileName As String Const kInitialFile = "F:TestbedTest.txt" Set fdFileSelection = Application.FileDialog(msoFileDialogFilePicker) With fdFileSelection .AllowMultiSelect = False
[Code] .....
When I execute it, the file picker goes to the right folder but does not highlight the file test.txt even though that file name shows in the File name text box. Is there any way to correct this?
hello everyone, i really need some detailed help as the deadline is approaching and I need to find a solution for this. Any help would be greatly appreciated
I currently have a batch file that ftps a text file from a Red Hat Linux Server to my W2k C:. I would like to make another command in the batch file that imports this text file into an existing access table. I would like the text file to repopulate the table everytime it is imported. I do not want the data added on to the existing data in the table.