Search:
Type: Posts; User: mcleyn
Search:
Search took 0.00 seconds.
-
Thank you very much. That was the exact problem.
-
Hi there,
I have a form with a text book that is bound to a table. I would like to keep two decimal places when I enter a number inside the textbox. For example, $47.12
I have set the properties...
-
Yes I agree with you. However, I will see what I can do with this article. Thanks again.
-
Hi there,
I have made a parameter query that is linked to a report, prompting the user with [What codes are you looking for?]. The Code field contains a variety of codes. However, when the...
-
Wow! Thank you so much ScottGem. My query column that I made had spaces in the name which was why it was not working. I did not know such a small thing could make such a big problem. Thank you!
-
Both names are the same.
In the query I have made a column called Total Funding Requested which adds funds over four years.
In the detail part of my form I have a Total Funding Requested text...
-
I have triple-checked the object name and both are correct.
What else is do you think the problem may be?
-
Hi there,
I have made a report from a query. I want to sum the totals from a totals column. I have had luck summing the totals from my other columnms by putting a text box control source to...
-
Ok thank you very much for your help!
-
Ok wonderful. That works perfectly. Is it possible to have this textbox that holds the answer of the totals to have another control source that puts this answer back into my table?
-
Hi there,
I am trying to produce a total sum text box from four text boxes inside a form.
I have tried writing the following macro for total sum text box but it does not work:
...
-
I needed to take the password off in the back-end as well.
-
Thank you very much. I have solved the prolem.
-
It's a regular .mdb file database. I never had to make any new file for it... would you have any ideas how to solve it otherwise? I'm in a huge pickle.
-
Hello,
I have an Access 2000 database.
I recently set a password to the database by going to Tools > Security > Set database password.
When I open the database it asks for a password so I put...
-
Hi,
I am using Access 2000. I have a database with a front-end and back-end. I currently have 4 tables that are linked to the bank-end.
I want to add a new table but I also want this table to...
-
Hi,
I am using Access 2000.
I have a form that allows users to input information quicker.
My question is: My form has gotten to long and cluttered. Is it possible to have tabs at the top of the...
-
This is the only WHERE clause in all my code:
sql = sql & "WHERE (" & Me.Filter & ") ORDER BY tblMain.ProjectCode;"
So should I add the WHERE (tblFiscalBudget.FiscalYear.. to this?
Yes I am...
-
Ha! I see!
So I shoud add this:
WHERE (FiscalYear = '11/12') ORDER BY tblMain.ProjectCode;
to the original code that I posted?
-
Ok so I have Debug.Print sql and this is what I was given:
SELECT tblMain.ProjectCode, tblMain.EventDate, tblMain.Status, tblMain.OrganizationName, tblMain.Province, tblMain.ProjectType,...
-
Exactly I thought so to. So I debugged the error and it gives me a highlighted: 'Me.RecordSource = sql'
This highlighted area is below the sql that I just posted. Then I assumed the error was...
-
I understand what your are saying but am still a little unsure of how to correct it in my sql statement. Again the error specifies it is in the FROM clause of my sql statement, however what fiscal...
-
Thank you very much. I just changed the name to Fiscal_Year and I no longer get the error.
-
Hi,
I am using Access 2000.
I have a form that shows all the projects being held inside my database.
I have made drop down boxes in the form with VBA to filter the projects.
I am getting an...
-
-
HI!
I would like to save up to 5 records in one field. What is the best way to do so?
-
Ok sounds I comprehend everything your saying up until that I have to assign a handler.
How exactly do I do that?
-
I have seen before in a database a certain combo box.
I am using MS Access 2000 and Visual Basic.
This combo box had 5 choices, all these choices had a control source to a field called Initiatves;...
-
Thank you however I have tried a listbox with a multi-select property, it allowed me to choose up to 5 options but they did not show up as new records in the field.
Perhaps you are right about the...
-
I have seen before in a database a certain combo box.
I am using MS Access 2000 and Visual Basic.
This combo box had 5 choices, all these choices had a control source to a field called Initiatves;...
-
My apologies for the quote asking you how to copy the module, I have figured it out. Thank you very much for your help indeed.
-
OK thank you very much. Could you explaing how I copy the module so the query will work?
-
I have a form called, frmDetail, which is one of my main forms.
Inside the frmDetail I have a drop down box with a list of different choices.
All of the choices inside the combo box are different...
-
I have a combo box with three choices; Innovation, Competitive and Amenities.
The Control Source field for these choices is called; Initiatives.
I want the user to be able to choose 1, 2 or even 3...
-
Ok thank you very much, your help is very appreciated.
-
If you have tables that are linked, and you want to make a new file of an original database. How do you take the links off the tables, so you can delete record in one file without the records being...
-
Actually I was thinking. I just want to put new records in for my tables and front end stuff as well. I mine as well just copy over the front end stuff like forms, queries and reports and then just...
-
Ok I copied the front end and then imported the tables but they still are linked. Can you explain how to unlink the tables?
-
OK yes now I understand the links. I found out the names of the back ends by looking in the Linked Table Manager. So no that I have done this; to make a new copy should I break the links? How do I...
-
Do you mean make sure there are no relationships between the tables? How do I make a copy of the back ends?
-
Acutally it didn't work.
I copied the file and then opened it and started to delete my records. When I opened the original file the same records were deleted.
Is it possible to copy the file and...
-
-
I currently have a database with MS Access 2000.
I want to make a new database that has the same fields and forms etc. as my current database the only thing different would be the data.
So...
-
Thank you Perito for all of your input. I have found the problem, I was missing a few commas is some of my sql statements. Thanks again!
-
These are the sql for the two queries I have.
tblMain query:
SELECT tblMain.Province, tblMain.ProjectTitle, tblMain.ProjectDuration, tblMain.ProjectType
FROM tblMain
WHERE (((tblMain.Province)...
-
I have pasted here the procedure that I am having the error with, you can see below the highlighted line of code that is giving me the problem. Is this what you are asking for?
Private Sub...
-
Thank you very much for responding. I have looked over my code and I have declared the sql variable as follows:
Dim sql As String
I have used single quotes where necessary however I am still...
-
I am running a database using MS Access 2000 along with Visual Basic.
Inside the database I am running a specific tracking summary form that takes information from a populated main table.
...
|