Expression Is Not Compatible With Web Is Being Displayed
Nov 11, 2012
I have two tables, [ATWelding] and [Results] . They are linked as they both have Weld ID.I want query to show any ATWeld ID that doesnt match a Weld ID in [Results].I can't use SQL as my database is on the web compatible platform. I attempted to do this using InStr([Results]![Weld ID]) in my Weld ID ATWelding criteria on a query but as I am using the web version an error message saying the expression is not compatible with the web is being displayed. I can run the query in my web database?
View Replies
ADVERTISEMENT
Jan 7, 2014
I used the code in the link below to get the login id returned on a form but I am having trouble now that I rolled out the database the code gives an error if the user has older than 2010 and even on a new machine that has access 2013 what is the best code to use? to return the log in id to a form?? without worrying about what version of access they have it wont be older than 2003. URL...
View 3 Replies
View Related
Apr 10, 2015
This Access database is Web Compatible and is hosted on SharePoint. I have a form with a subform that display collections of records. As you can see in the attached image, the user selects a record from the combo box which filters the form/subform below. Each record will contain more than 1 item.
What I want to do is mimic a "Split Form". But, the last thing that is missing is being able to select an item from the subform (datasheet view) which displays several items in the record and have that item be displayed in the form. Currently, I have to use the record selector buttons at the bottom of the form to have the item I want displayed in full. But I want to be able to click the item in the subform and have it populate in the main form on this page.
View 1 Replies
View Related
Jun 8, 2005
Good day all
Heres what im trying to do:
in one textfield i have =Count(*)
this returns all the records in my db.
now i want to split it up. i want to count all the records for each month.
my field name is datein_now but its just a normal textfield and not a date field.
example in field: 05/02/02 10:24:31 AM.
also got a datein textfield:05/02/02
i had
Count(*) where datein_now between 05/05/01 and 05/05/31
please help
lee
View 1 Replies
View Related
Mar 4, 2014
Whenever I use a look up field to enter values, I get the ID number displayed instead of the value (name). How do I rectify this error.
View 2 Replies
View Related
Jan 28, 2008
Hi,
I have a order system which allows customers to place items on. When an item is selected and a quantity has been entered and add button is selected, this adds the item into a listbox with all the details.
Each item that is selected a quantity is selected, this would then work out a total price and this total would be displayd within the list box too.
i want to add all the totals up for that order and have it displayed within a text box.
for example:
product ID, Name, quantiy, item price, totalcost
P0001 Top 5 1.00 5.00
P0002 Top 4 2.00 8.00
P0003 Top 3 1.00 3.00
i then have a text box where i want to display the overall total for these items within. hope this helps. im really stuck on this one!!!
View 4 Replies
View Related
Apr 8, 2008
Hello,
I have a querie that calculates the average of two sets of times taken from a calculated figure in a table.
My problem is that the returned value seen when the querie is ran needs to be of a clock format. Eg 0.75 needs to read as 0:45
I have attached a Database to help, as i am unable to do this.
Any suggestions given i am greatful for.
View 3 Replies
View Related
Apr 29, 2005
I'm sure this is simple and I'm just missing something...
I have a combo with two columns and the row source set up as a query which returns two columns.
When I click the drop-down arrow for the combo box, I get exactly what I expect.
What I want to do is initialize the combo box so that the "default" selection is displayed in the "text" or "value" section of the box. I also want to be able to update this when the user makes a selection.
I have no problems when using a list box with something like:
listbox.value = <Some Index in the listbox>
With the combo box, I've tried:
combobox.text = xxx
combobox.value = xxx
combobox.column = xxx
combobox.itemdata = xxx
combobox.listindex = xxx
The value property sort of works -- It displays the data from the first column right justified in the "text" section of the combo box. I need to have both columns displayed the way they are when the combobox is dropped down.
Any thoughts?
Thanks in advance...
View 3 Replies
View Related
Aug 1, 2005
Hi,
I am trying to choose an entry from a COmbo Box which ahas a Lookuop underlying in it. I then want to display the additonal four entries in the form it self. The data is already created and displayed in a query. The primary key gets displayed but thte other data cannot be displayed. Is there any way I can display the other details eg: Firstname, Surname Age in the same form but under different fieldnames. I am not sure how to do this.
I could retype it all in but that is uneconomical. Any ideas? Please help.
Thanks.
View 2 Replies
View Related
Dec 2, 2004
New to Access - I have a database which currently has 200 records. When I run a query or report it's the 150th Record which comes up first. I do get all the information but would like to know how I set it up that it's the 1st record which is taken first and then so on.....
View 1 Replies
View Related
Dec 22, 2004
When I view data in linked tables in MS Access containing foreign characters (umlauts, accents, etc), the foreign characters are not being displayed properly. It is not a font or Access setting because I am using a separate similar database (also containing linked tables) where the foreign characters are being properly displayed.
Is there a setting I'm missing in the linking of the tables? Not sure where else to check.
View 1 Replies
View Related
Sep 8, 2006
I have successfully used an Expr code in my query to get the calculated result that I need. My problem is I can't seem to display the results on a form. I get the error "Name?"
When I try to find the query on data control which I used, it does nothing but shows me the fields from my table. How can I get a query expr column to display in my form?
the name of the query is "together" and the column's name is "everyone"
Can someone please point me in the right direction
View 2 Replies
View Related
Jul 31, 2013
i want to make it equal to my forms adjusted width but i don't know how to do that. Also i thought it would look like a form enwrapped within a rectangle or a square yet its gluded onto Access with no border
View 2 Replies
View Related
Apr 12, 2006
Hello,
I'm trying to limit the number of text characters displayed in various fields on a form. I want it to appear so that after a certain number of characters it then displayed "..." indicating there is now information in a field.
Thanks for any help!
View 1 Replies
View Related
Oct 18, 2005
Hi I'm a teacher and have to set targets for classes, I have created a database which allows me to input targets for the classes. I now need to then display the class target for individual pupils in a new layout. I am sure there is an easy solution and I am looking at the problem from the wrong direction. Thank you for any help
graham
View 3 Replies
View Related
Jun 2, 2005
I have a query that looks through a table and shows me any calls that have a status of either 'O' 'or 'C'. What I would like to have in the query result is the O or C replaced with the words Open or Closed. Then when my count will make alot more sense rather than having O 29 etc.
I have had a look through the forums on the net and I am convinced this question has been asked before, but I am struggling to find the key word to search for
Kindest Regards
View 5 Replies
View Related
Nov 29, 2005
I have a continuous form based on a query with the criteria as all records where a certain field is null. From this form, the user can fill in values for the null field. I then want to click a button on the first form to open another continuous form showing the same records so the user can go on to do something else. The problem I have though, is that if I base the second form on the same query as the first form, any records where the user has filled in a value for the previously empty field will now not be included in the query results. Is there a simple way of doing this?
View 2 Replies
View Related
Apr 24, 2008
Hello again my forum o' saviours, Current filter: WHERE (Assignments.[AcademicYear]) Like ([Please Enter Academic Year])AcademicYear is a field in the Assignments table (duh). In this same query, I have a couple fields (equations and if/thens built on the assignments table) that will need to be used as further filters. I thought something like WHERE ((Assignments.[AcademicYear]) Like ([Please Enter Academic Year]) )& (len([groupwinterbox])+len([groupspringbox])+len([groupfallbox]) > 3) would work, but I keep getting pop-ups asking what the values of the three query-based calculations are. Where did this noob screw up?
View 9 Replies
View Related
Aug 12, 2005
Some of my collegues have been experiencing this problem with a very simple database i knocked up for them. First off some background. I have a main form (frmproperty) with 3 subforms linked to it(frmroomdata, frmlocation and frmsample). by a property code. Two of these subforms are linked (frmlocation and frmsample) these are linked by location code which is an autonumber.
These are laid out so that you fill in room data first, then location data then finally sample data. However after the location data has been filled out and a user attempts to move to the first combobox on the sample subform a message pops up saying that another user has altered the database and would you like to save changes (Impossible as they are using the database on a local drive). After this happens they reopen the form and in all the frmsample fields is "#deleted"
This doesn't happen every time...infact over the last 2 days i have been entering data myself to try and get this error with no luck. Has anyone else come across this and know how to fix it?
Thanks in advance
Matt Collins
View 2 Replies
View Related
Oct 14, 2005
Hello,
I'm new at this, but here goes. I have a memobox on a form that I set the DefaultValue to display instructions for what to enter in the memobox. I would like these instructions to be visible until the user clicks or tabs into the box. Then I would like these instructions to disappear when the user begins to type something in. I've tried using several different event scenarios, but none does exactly what I want. I don't want to use a control tip as it won't appear until the user actually enters the memobox and I want the instructions to be visible before that time. However, this is what I've done at this point because I haven't been able to fiqure out how else to do what I want to do.
Any help would be appreciated; I'm sure this is something very simple for all of you, but I've spent several hours trying to work my way through this.
Thanks, Charlotte
P.S. I've read many of the posts, and have gathered many helpful tips on a variety of Access topics. Thanks to all of you out there!
View 8 Replies
View Related
Feb 28, 2006
So...I have a table with 2 fields: Name and Times Accessed
I have three names in the table: Shane, Bill, Chris
There are multiple entries for each name with no primary key set.
The Times accessed are as follows:
Shane 2
Bill 2
Chris 1
Bill 3
Shane 5
This is what I want to do if possible:
I will have multiple text boxes on the form that will display running totals for different people in a table.
So i have three text boxes on the form. 1 for each name. i want that textbox that corresponds to each name to keep the running total for Times accessed. So, for Shane it would be 7, bill would be 5, and chris would be 1.
How/where do I do this? need more info?
Thanks...
Shane
View 1 Replies
View Related
Sep 11, 2006
I know this is a simple question. I searched but could not find what I was looking for. Or it is handled in differently than what I am thinking.
I have a field where I enter a dollar amount. But if I do not enter a dollar amount the field displays $0.00. How can I make this field blank if no dollar amount is entered.
Thanks
For any help I can get
View 2 Replies
View Related
Sep 14, 2006
I have a form with loads of calculated textboxes (using expressions).
Some of these also rely on other textboxes that are being calculated when the form loads.
If I load it once, some of the textboxes display #Error! but most don't.
On closing it and reloading it a second time, the textboxes that displayed #Error! the first time now display a correct value and some other textboxes display #Error! instead.
Occasionally, every control works perfectly.
Is this something to do with when the calculation on each control is run and that if the dependent calculations don't finish quickly enough?
If so, is there a way round it?
View 6 Replies
View Related
May 6, 2014
I saved my form with a particular name and I have used that name all throughout my code and it still works fine. But when I open that form, the name I see on the top of the form is not that name at all. It's actually some value I gave a combo box a while ago.
View 2 Replies
View Related
Jan 19, 2015
I have a combobox which lets you select from a list of pseudonyms. Each pseud belongs to an author; authors can have multiple pseudonyms and exactly one main pseudonym. This is the table structure (picture of relationships attached below):
Code:
tblStory: StoryID (PK), AuthorID (FK), Title, etc.
tblAuthor: AuthorID (composite PK, autonumber), MainPseudID (composite PK)
tblPseud: PseudID (PK, autonumber), Pseud, AuthorID (FK)
The combobox list shows all the pseudonyms and then stores the corresponding AuthorID. At the moment, the pseudonym displayed in the combobox (once a selection has been made) is simply the first alphabetically for that particular author: for instance, if a story has AuthorID = 5, and Author 5 goes by anon, anonymous, and unknown, the combobox for that story will display "anon".
How can I make the main pseudonym (tblAuthor.MainPseudID = tblPseud.PseudID) be displayed instead?
Control source is tblStory.AuthorID
Row source:
Code:
SELECT tblPseud.AuthorID, tblPseud.Pseud, tblAuthor.MainPseudID
FROM (tblAuthor LEFT JOIN tblPseud ON tblAuthor.AuthorID = tblPseud.AuthorID)
LEFT JOIN tblStory ON tblAuthor.AuthorID = tblStory.AuthorID
ORDER BY tblPseud.Pseud;
View 1 Replies
View Related
Jun 23, 2015
im working on a report at the moment that will generate a standard NIP (nutritional information panel, similar to whats on the back of pretty much all packaged food products, see link below for an example)
[URL]
this in itself is pretty easy, however depending on which market we're selling to, different countries have different requirements for which data is to be shown, ie some markets might require we show how much sodium but not how much fiber, others might require us to show how much carbs and sugars but not how much vitamin C and so on (all up there are 16 different variables for nutritional info, due to size requirements on our packaging we cant simply display all 16 all the time)
at the moment im designing a form which has a drop down box (for the user to select a product) and checkboxes for each of the 16 variables (kilojules, carbs, iron, trans fats, sat fats, etc) following this ive got a report that has all 16 variables on it
i can make the variables that arent ticked on the form invisible (by adding a bunch of IF or Case statements, on print of the report, that determine whether the corresponding checkbox for each variable has been ticked and setting the "visible" attribute to true or false accordingly), however when they are invisible there is still a blank space where the field is meant to be ive got all the fields grouped together, is there any way of making fields invisible and then pushing all the visible fields together so there are no blank spaces?
View 3 Replies
View Related
