Search results for query: *

I have created a hyperlink field in my table (tbl_ChkRequests) using hyperlink datatype. The field shows the blue hyperlink but clicking on that field does nothing. I manually added # sign both before and after the sting which allows the hyperlink to function. Hovering over the field with...

How do you change the default value of a memo field. Apparently the default value is 255 characters. If you change it to a greater value than default, will that delete the data that is already in the field? Thank you. Hefly

Problem: The field [PermitTerm] contains nulls. Where the field [PermitTerm] is null, all the queries I try only return nulls. I need to add PermitTerm to LeaseTerm and get a number answer. I need to change nulls to zeroes so I can use PermitTerm as a number to add to other numbers. I...

My table stores the date in the Now() format. I need to run an aggregate query to count the number of times the record is stored by date, i.e. the number of times a record is intered on any given day. How do I convert? Thanks Hefly

How do you capture the users who are logged into an Access 2010 backend? Thanks Hefly

My access report suppresses text and in lieu of the text I get the error message: #text! What does this mean? Thanks Hefly

I have a variable length string. The beginning of the string begins with text followed by a colon. I tried to parse this in excel. I exported into an excel spreadsheet, but it converts the sparsed text into a date. Not a text string. Beginning of the string is as follows with the : as a...

How do I format a number in a text box on a report? I have the following expression in a text box on my report: ="as listed in the " & [County] & " County, " & [State] & " totaling " & [LEGALACRES] & " acres, more or less." I have formatted LegalAcres as three decimal places in both my...

I am not able to make changes to my forms. I was told that Access 2010 has corruption problems. I have applied Office SP1 but I have not noticed any difference. If I attempt to modify an existing form, the form cannot be saved and the database will not close unless I abandon the changes. I...

the following query does not filter my dates from field "dated". There are no other criteria set. My query: SELECT [tbl_2010 Transaction Details].Dated FROM [tbl_2010 Transaction Details] WHERE ((([tbl_2010 Transaction Details].Dated)>"#12/31/2010#")); I expect the query to return only...

I have created a report footer where I want to sum a field. I have used the following: =Sum(Nz([Net],0)) And =Sum([Net]) Both return an error "Invalid use of null." How do I sum a field with nulls in my footer? Thank you. Hefly

I did a re-install of Access 2010. There is no longer the little black box on the upper left hand corner of my form in design view. I want to be able to click that button to pull up my Property sheet. How do get that "little black button" to reappear? Thanks Hefly

Is there a way to convert query text results as hyperlink? I have two text fields, MyPath and FileName Can I concatenate these fields into a query result that is a hyperlink? I've looked at the Format function, but can't find any reference to formating my concatenated field to hyperlink...

How do you show date as Year/Month? 2011/11 2011/2 I can only get "yyyy" SELECT DatePart("yyyy",[Dated]) AS YrMo FROM tbl_Leases; Thanks Hefly

I am trying to connect my access tables to a backend. Some of my access applications, with multiple tables, connect all tables on the the first attempt after browsing to the backend. Other Access applications require browsing to the backend for each table in the application. That's ok with...

I imported a field from Excel into Access 2007. The field is a varying number of three digit characters separated by a comma, e.g.: MM1, MM2, MM3 MM1 MM2, MM3 When I imported the data, the table Format box had an @ sign. Only one of the three digit strings appear in the field. E.g.: MM1...

I created an Access front end that is linked to a server. I compiled the front end into an accde file. Then, I changed the extension to accdr. The user, who does not have access on his machine can open the program, the program tries to connect to the tables. No objects can be viewed...

I am trying to filter on a datasheet form. I can only filter using inequalaties and sorting. The dropdown list, where I can sort by selected items is no longer available. Any idea how to get this feature to work again? Thank you for your help. Robert

I have a two digit number stored as text. Some numbers have a leading zero. 01 11 23 02 When there is a leading zero (number is stored as text), how can I use an access query to strip the zero from the text sring? Thank you. Hefly

I am trying to strip the first and last character off of a four character string in a query. The following two expressions work, but I would like to combine expr1 and expr2 into one expression in a query: T1: Left([T0],Len([T0])-1) T2: Right([T1],Len([T1])-1) Thank you for your help...