Hey all,
just have a small question...
Normally in a form if you use the '&' in front of a objectname or something like that it will underline the first following letter meaning you can use the 'ALT + letter' combination to use it.
Now I want to use the '&' sign in a label, without having it do anything like that. I just want it to display the sign, anyone have any ideas on how to do this?
Cheers,
Thomas
My teacher instructs me to make a 'multiple item form' in regards to signing in and signing out of a dentist ( my scenario)...The fields i have are : Appointment ID, dentistID, Appointment time, Appointment Date and customerID..i have created have the multiple item form and i am now displayed with the fields.
View 6 Replies View RelatedCan anyone tell me if the % sign can be used, and if it cant is there any other way around this?
View 6 Replies View RelatedHi I would like to know if it is possible to display the & sign. I need to beable to use this both in form titles and on command buttons. When ik type it in as a caption it is displayed but as soon as I come out of edit mode I am left with a _ in place of the &
any help would be great. Thanks Paul Evans
I have the following in a select query
TimeLeft: CDate([FinishingTime]-Time())
If FinishingTime is LESS than Time() I want it to show a negative sign to show that the time has past. How do I do this?
I have table with one of the columns with number (amount) that can be positive or negative.
I want to add new column of sign - 'H' for positive or 'S' for negative.
Hi,
I have a problem displaying the £ sign in my query. Instead of the query displaying £448.87 it displays 448.87.
You can see from the below image that the value of AllCost is £448.87 and I don't understand why its displaying 448.87 when I run the other query called All Cost 2. The Nz function is used to display £0.00 if the AllCost field is null.
http://img01.picoodle.com/img/img01/6/11/15/f_82932abff5f8.jpg
The below image is when I run the "All Cost 2" query
http://img01.picoodle.com/img/img01/6/11/15/f_489aad3dce48.jpg
Thanks!
Chris
I have a table that is joined to two tables. When I view it in Access 2010 the plus sign is set to one table. How can I make it view the other relationship?
View 1 Replies View RelatedI want to create a user name and password in to access my data base
View 3 Replies View RelatedIs there a way to reverse the sign of a numerical field at data entry time and store the negative results...i.e. a quantity field (shipments) keyed as +100 to be stored as -100? I have tried several input mask solutions but none worked.
Thanks for any help or suggestions from an Access novice.
I have an accdb built using Access 2013 that will run with in 2010 Runtime. I am about ready to distribute the application, and am starting to do some research.
When I attempt to package and sign the db using the feature in Access 2013 it asks for me to "Confirm Certificate".
Before I go buy one I want to 1) try to create on myself and 2) learn about some good places to buy them.
1) I created a "Self-Signed" certificate using IIS, but the certificate doesn't show up on the list of certs when I attempt to package and sign the accdb. Is there a way to use a "Self-Signed" certificate to package my accdb?
2) If purchasing a SSL is the only option. Where is the best place to buy a SSL that I can use to package and sign accdbs from Access 2013?
I have created a button to display the current time ( sign in and out).
It works fine with this code Me.field = time$
However i need a code beneath it to run the actual query that will display this time onto the table...
I have attached an image of one of the query, I need it to run.
I am trying to add a percentage sign (%) after a number I get from a table, thus the number 1,5 should display 1,5% and NOT 150%.
I am using the Format Property of the text field.
I tried #,##% which converted the value to a percentage (1,5 became 150%) Then I tried #,##"%" and #,##\% Access ignored both and changed the value in the property field to #,##% Using the Format function is not an option because it is a bound field which should be editable.
hi.. i have one table with fields 1-8
2 forms are used to fill in the details for each record using the primary key on each form.
eg
FORM1
jobid
date
day
time
price
FORM2
jobid
pickup
dropoff
vehicle
is there a way that on FORM1, i can indicate to my user whether or not any details have been entered into FORM2
maybe a colour system.. eg
if table.pickup and table.dropoff and table.vehicle are empty
form indicator on FORM1 is red (to show that none of the details on FORM2 have been entered)
else if table.pickup or table.dropoff or table.vehicle are not empty
form indicator on FORM1 is green (to show that atleast one of the fields on FORM2 has been entered)
it doesnt have to be a colour scheme, it can be wording.. eg
Form2 Empty, or Form2 Completed...
just some kind of sign to my user..
anyone ever tried or used something like this before?
I'm having an issue with pound signs in my table for specific items. I've create a DB that when you click a command button it opens a form and in the form it has a notes field. In the notes field once where i had data is now pound signs.
The DB is setup so when you click another command button to close out, it saves the record. It works 98% of the time but the i'm concern about the other 2% of the time.
I get a negative value when i run the below expression.
The expression picks the month from the field txtmonth in form "frmYearToMonth" and search's the crosstab query "ctbYearToMonth" for the corresponding value in txtMonth.
=DLookUp([Forms]![frmYearToMonth]![txtMonth].[Value],"ctbYearToMonth","")
The value is correct but there is a negative sign before the value how do i eliminate the negative sign.
As I am having difficulty keeping my database at work digitally signed due to other users using the database; I was curious if I could create a batch file to automatically run at night to sign the database, so that it can automatically update in the AM, without being prompted questions. Or something of this sort?
View 12 Replies View RelatedI have several reports where the currency was always reported in dollars so for the fields in question I had a format of $#,###.00 which printed the dollar sign in front of the amount.
As the system has now become more sophisticated I need to print out a currency symbol depending upon the client. I have a currency table that links into the client so my query 'behind' the report holds the right symbol but how do I get it ito the report. I Know I can define a second field that will hold the symbol but to me this is a clumsy way of doing it. Is there anyway I can put the symbol in the control source for the data or into the format of the field or some other way?
I have a command button on a Web Mutli-Record form that is using a "= [Report_URL]" value within the Hyperlink Address property. This all seems to work other than the fact that when the link popups up it has a "#" on either side that basically makes it an invalid address. How do I get rid of the # signs to get the web address popup in the URL when a user clicks on the Command Button that is associated to the row the record is on.
View 4 Replies View RelatedI have tried the count(field name) and the sum(field name) but neither of them are giving me the grand total only the count/sum of that row. Here is my code, please look - I'm sure its something small and stupid
SELECT [qry_Refi_Yield].[LOAN NBR], [qry_Refi_Yield].[BORROWER], [qry_Refi_Yield].[PURPOSE], [qry_Refi_Yield].[FUNDED STAMP], [qry_Refi_Yield].[HSS], [qry_Refi_Yield].[UNIT TEAM], [qry_Refi_Yield].[Cycle Time], [qry_Refi_Yield].[Total Yield], IIF([Cycle Time]<=30,1) AS Yield
FROM qry_Refi_Yield
GROUP BY [qry_Refi_Yield].[LOAN NBR], [qry_Refi_Yield].[BORROWER], [qry_Refi_Yield].[PURPOSE], [qry_Refi_Yield].[FUNDED STAMP], [qry_Refi_Yield].[HSS], [qry_Refi_Yield].[UNIT TEAM], [qry_Refi_Yield].[Cycle Time], [qry_Refi_Yield].[Total Yield]
ORDER BY [unit team], [hss], [funded stamp];
past tries: count([qry_Refi_Yield].[Total Yield])
count(borrower)
Hi,
I was using access 2000 to build a small office app. It will be on a network and will generally be used by only 2 or 3 people(max). I was wondering if the default jet technology would be good enough for this. If it isn't, what should I use? I looked at other options such as msde and ado but it's a bit confusing when you're new to this stuff.
Thanks,
scratch
There are times when it is just necessary to have a little rant, a canniption if you will.
For the last few weeks I have been working off-and-on with a new database for a salmon hatchery. One of the forms I designed contained a subform in continuous form view that flickered inordinately when first loaded. Now, there's a lot of code going on behind controls etc to run sql updates or deletes or appends depending on what the user clicked. There was also some code to alternate the row color of the continuous form. I spent literally days trying to find what part of my code was causing the problem.
I swore a lot.
I searched.
I eventually gave up as other priorities began to arise at work. I resigned myself to my fate.
Then I discovered, quite by accident, that the problem arose by the use of some unassociated labels being present on my form. I removed them, replaced them with labels associated with a control, and presto: the form flickering/reloading magically vanishes.
Great.
But what a colossal PITA for something so bloody stupid. There's absolutely no reason why this should occur IMHO. Honestly: it's hard enough to learn VBA, SQL, and relational db design without having to deal with poorly documented glitches like this. There are days when I think I'm finally starting to get the hang of Access, then something like this comes along and I want to send a lynch mob to redmond! :mad:
Ok, end of rant :) Hope the solution to my problem comes in handy for someone else someday.
Hi,
What i want to do is have a field called "monthlyhourcount" in my query that totals all the hours in a field i have in a table, the field in the table is called "hours worked" were a figure is entered, i need my query to give a total of all the figures entered. so far in the expression builder i have :
monthlyhourcount: [JobListMonthly]![Hours Worked]
when i run the query with this it gives me the seperate values, i need one total value.
any ideas guys?
Thanks
Conor
I'm fairly new to Access (2000 is the version im using), and I'm not sure how to do several things within a form:
1) make cursor in a text box jump to the front (left) when clicked on
2) Lock (and grey out) a text box once data has been entered into another
3) assign a field to correspond with another, and to have this shown on the form (ie: having a list of names and their corresponding phone numbers assigned to each; then on the form, having a combo or list box with the names that a user can select- once a name is selected, their phone number appears automatically in another text box)
4)Locking screens or subforms when moving on to another (either by pressing a button to open another form, or by selecting a field in another subform)
thank you in advance for your help and advice
Hello,
This will probably generate a few good laughs but here goes!
I have been given an Excel file with 6 fields about 20 chars in each field.
This file is a whopping 250 records. I would like to be able to add, change, delete and search records.
The DB would need to be shared by 2 users on a home network. Both are using Windows XP.
What would be(heres your chance!!!) the easiest solution for this?
This is for someone who wants to keep it simple. If it was simple though, I guess I would not be posting this!!! Haha.
They best part is they have MS-Works on their machines.
Any help or better yet a completed solution would be much appreciated.
Thank you
Take Care
Tom
hi. I am trying to write a code to sum the total cost of all jobs that are selected as 'yes' in a combo box.
Once the user selects 'yes' in a combo box, they enter in a cost for that specific job. Each client may have 10s of jobs. I need to write a code that will sum up all the 'yes' selected jobs for a client. I know it should be an 'if' statement but I can't seem to get it to work. I need this value for a report. How would I do this and where would i put the code.
Help is appreciated.
Here is the code that I was thinking of, I don't think its right but it might be a start.
Dim Count As Variant
Dim CountImplementedTotal As Variant
CountCost = 0
CountImplementedTotal = 0
Dim rst As DAO.Recordset
Set rst = CurrentDb.OpenRecordSet("ECM Details")
Do While Not rst.EOF
If rst![AUDIT ID] = Forms![audit info]![AUDIT ID] Then
If rst![Has Measure been Selected] = "YES" Then
Count = Count + rst![Total Measure Cost]
End If
End If
rst.MoveNext
Loop
Text47.Text = Count