Search results

Hi Moniker. I solved first problem. When I use Field3.ControlSource = Left(Field1, 1) & Left(Field2,1). In a form looks fine. But cannot see value of Field3 in a table. My other question. How to cut last character from Field4?

Hi All. I would like to create validation if user forgot enter data in a form. How to create message if user forgot to enter data on some of the field(s) and try to go to other record by click Tab button or use navigation button. In that case will pop up message with a list of empty field(s) and...

Hi. Thanks Peter. My question is how to create conditions to get a result in my cases. Thanks.

Hi All. I created form with some fields, RESET and QUIT buttons. All works fine. But with RESET button I have problem. I would like when user open new form RESET will be not active. Only when user open new record or did some changes on existing record in that case RESET becoming active and after...

Hi All. Is there a way to index and create a unique identifier using a combination of fields (eg. User# + Provider + Date)? Thanks.

Hi All I would like to insert in my cystal report image that user will click to open subreport. If is it possible how to do it? Thanks.

Hi All. I have problem to fix a view in MS SQL. It looks like: SELECT Date_P, -SUM(is not null [Result]) AS Complete, -SUM(is null [Result]) AS [Not Complete] FROM dbo.Prob GROUP BY Date_P Message says: "Incorrect syntax near the keyword 'is'." How resolve that problem? Thanks.

Hi All. I created query with dialog box in Access : SELECT (Format([Date_P],"mmm yyyy")) AS [Date_P], Result, Count([Date_P]) AS Pos FROM ABC GROUP BY (Format([Date_P],"mmm yyyy")), Result, Format([Date_PAP],"yyyy") HAVING Result<>"neg" AND Count(Date_P>0 AND (Format([Date_P],"yyyy")=[Please...

Hi All I try to create a query based on Table1 and fields Date and Result. Is it posible to get a query that calculate two amount of Result field when that field is null and not null? That two values of Result field I will use to create monthly Pivot report in which each bar will display amonts...

Hi All. Form1 has ComboBox1 and 2 buttons: OK and CANCEL. When user selected value in ComboBox1 and pressed OK preview report will open. I would like when user click CANCEL value in ComboBox1 will canceled but Form1 will not closed. How to do it? Thanks.

Hi All. I try to figure out how create a view or stored procedure parameter value. I don't have a any questions how to create query parameter value but I don't know how to create a view parameter value. If is it possible how to do it? Thanks.

Hi Al. I'm using project Access database. Is it possible create UPDATE query in such database type? Thanks.

Hi All. I created monthly Bar Chart report based on a query, where TAB_RES is table with DATE and RESULT fields. That report displays bars with data value count amount of DATE per month where RESULT is Not Null. Now I would like to create a query to show on my Bar Chart report bars with two...

Hi All. I would like to create Bar Chart report based on a TAB_RES table with DATE and RESULT fields. And I would like to show on my Bar Chart report amount of calculated DATEs where RESULT is Null and RESULT is Not Null. How to show calculated values for two conditions in one chart? Thanks.

Hi All. In my porject I use Access form like frontend and SQL Server like backend. Question is: Is it possible use temporary table SQL Server for VBA Access if yes how to do it? Thanks.

Hi All. I would like create dynamic demo form when my database is start up. Is it possible create demo using Powre Point or may be using VBA? Please, if some body has such form replay with attachment. Thanks.

Hi All. I would like create in my form buttons not only square or rectangel of grey color and also other forms and colors such as circle, oval or others? Is it possible, how to do it? Thanks.

Sorry. It is not complete question. I mean possible create Word report using Access database fields and replace those fields in according places. Thanks.

Create Word doc by database Hi All. Is it possible to create Word document report using fields from Access database and place those fields in according places in Word file. If is it possible how to do it? Thanks.

Hi All. In a Listbox I have a Name and Department fields. Is it possible to show each department with own color background in Listbox? If yes, how to do it? Thanks.