Hi all. I have tried searches on here and via google but can't find a difinitive answer to my question. What i would like to do is create a custom help file that will run when the user requests it. I know there is a property option to set a custom help file within a form but i am unsure of the correct process to do this to get it working.
Could someone please help me understand what needs to be done.
Thanks in advance.
I am just having a heck of a time, in trying to make a custom help file.
Has anyone had any luck? I sure would like to see a sample database, showing a
custom help file. I just about tried everything, but not to smart about setting one up.
I have tried the wizzard as well. I know where I get hung up is, trying to map the help file,
to the Help ID number.
Any help would be appreceiated
Hi! I'm working in Access 2007, and am having difficulty figuring out how to do the following.
I purchased some pretty .ocx buttons that I want to use in my db. I can't figure out how to import them for use. No, I don't want to just copy and paste them in. Any ideas? I hate the ugly, unprofessional looking command buttons in Access. Thank you!
KellyJo
In Access 2010 I made a custom ribbon.The File Tab still gives users access to features that should not be available to them such as: Compact & Repair, Encrypt etc.I spent a few hours looking for a solution but found none that works.It does not seem to be possible to hide the File Tab, but is there a way to hide the options it reveals?
View 3 Replies View RelatedIt is my understanding that a custom macro was built to pull text data from a file and import it into Access in the appropriate fields. This macro no longer works and will return the following error message:
"License information for this component not found. You do not have an appropriate license to use this functionality in design mode."
It only gives an option to click OK. When you do it shows a box called "Action Failed" that lists the macro name, condition, action name, and arguments with three button to click on the right of the box: "Step" "Halt" and "Continue". It appears that only the "Halt" button is available to be clicked.
Does this sound like an issue with the Access license or whatever license the macro might have? We're trying to decide if it's possible to restore the functionality of the macro.
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?
hello,
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?
Tokunbo
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'm using Office 2010.
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
[Code] ....
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?
HI all, I have recently created my own custom toolbar for my database which works fine on my computer, but when the database is transfered to another computer via a memory stick (needs to be done as it is going to be used on remote laptops away from the main network), the custom toolbar does not carry over. Instead of the custom toolbar being shown, the normal, main toolbars are reset to the default ones shown.
Is there a way of stopping the toolbars reseting when transfering the database so that my custom toolbar is the default toolbar?
Thanks for the help!
I have a custom toolbar in my application. However, it isn't visible at the top of the application window and when I try to make it so - via View - Toolbars - it doesn't appear on the list of available bars.
I had assumed that I had somehow deleted it, but I know it's still present somewhere, as when I try to recreate it, I get a message saying so.
How can I get the toolbar to be displayed? :confused:
I have a database for call outs, i had a problem with double booking, but cured that, my problem now is every time my work mates try to book me in that go into the debug box (accidently) all i need is a ok button only msgbox to say the time is already booked. can anyone plaease help.
here is my db if any one want to have a look
Hi folks:
when I create a custom toolbar on my db, would that custom toolbar be carried to other copies of my db? I'm hiding all toolbars using code and I need to display only one.
thanks
Since the introduction of 2003 when you create a custom menu you always get the 'Type in a question for help' tag and the min max close buttons. Is there any way of removing them or disabling them?
:confused:
I would like to create a custom autonumber to use as my primary key in one of my tables in my database.
I would like my records to be displayed as such C000001 , C000002 and so forth. Does anyone know how todo this?
Thanks in advance.
Hello, I am trying to set up a relatively simple relationship between numeric fields in two (already related) tables. The problem is Access doesn't really support this type of relationship... or in fact, doesn't have an interface for coding your own custom relationships (if it had one, this would be ridiculously easy).
But it doesn't. So I have to turn to you.
To explain my problem better, I'll use a visual aid.
http://img269.imageshack.us/img269/9123/db1zx2.jpg
My two tables are as follows, the master is called [Raw Materials] and details is called [Raw Materials Details] (the aptly named).
I guess I should rename the [Raw Materials].[Stock] to something else (as this isn't REALLY data redundancy). But anyway, what I want to do is have the [Raw Materials].[Stock] automatically equal to Sum(Stock) FROM [Raw Materials Details].[Stock]. To rephrase, I want the Total Stock field to be automatically equal the sum of corresponding stocks.
Either way, I have no idea how to go about doing this. Can anyone point me in the right direction?
Hi all,
I cant make work, a query with creteria filled within controls of a form. I will be more specific to make u understand what i want to ask.
There are 2 text fields and 2 combo boxes. All of them call a report (by pressing a button) from the main table.
in the "totalquery" query i call each control this way:
select tblPeople.name,tblPeople.tel,tblPeople.age,tblPeop le.Car from tblPeople where tblPeople.Name=[forms]![frmMyform]![combo1] OR tblPeople.tel=[forms]![frmMyform]![text1field] OR tblPeople.age=[forms]![frmMyform]![text2field] OR tblPeople.Car=[forms]![frmMyform]![combo2]
GROUP BY tblPeople.name,tblPeople.tel,tblPeople.age,tblPeop le.Car;
I want to make it display (the right) results if one of the text filed/combo is filled or with data, or all together or in combinations.
i use the OR statement,but it doesnt work if I fill in two fields/combos together and etc.
Anyone? :rolleyes:
Hello all!
Basically what I am wanting to know is how difficult is it going to be to do the following.
I want to have 8 searchable fields, first name, last name, MO, Job code, etc etc. I want to be able to type somthing in any one of these fields and then when i hit a submit button I want to to return to me all the data that corresponds to what I am looking for. I know I could just create a simple query from the query wizard but i want everything in the program to look uniform as to not throw every one off. How difficult would this be and how should I go about doing it. If you need more information let me know.
Wondering if it is possible to order by particular values??
That is I have a column (varchar) named "Status" with values such as; Entered, Active, Completed etc (I didnt design the DB).
What I need is to order by Entered, then by Active then Completed etc.. Is this possible??
Ive got this code for SQL; but it doesnt work in Access (03)..
ORDER BY
CASE Status
WHEN 'Entered' THEN 0
WHEN 'Active' THEN 1
WHEN 'Completed' THEN 2
ELSE 3 END, Status
I have a form with tab pages which I can not change the tab order.
When I bring up the Tab Order box no fields are displayed only a Custom Tab Order! Never seen this before.
Question is how to get rid of this and be able to change tab orders.
Thanks
I'm just creating my first db. When I'm on a form looking at a previous record (in this case a transaction), I need to be able to make a minor change to that record (such as the date for a repeat transaction), and then save the record as a whole new record. The button commands I found in the wizards only let me save over the current recond after an edit. Anyone know the easiest way to creaet a command button that does this? Thanks for any insights.
View 3 Replies View RelatedI trying to setup a custom yes/no.
In the table I set the yes/no format "Made";"Recieved" » lookup 'text box'
I made the form and in the textbox and did value list with made and recieved. but it's giving me the could be text when number should be used and vise versa thing.