I have a database that I need to edit a lot of fields on, but SSMS doesn't quite seem to be up to the task. First problem is that I can't seem to insert multiple lines of text into a field. Second is that any time I happen to have the Shift key held down when I press the space bar, SSMS immediately enters the data. Is there a better ...
I have an Access 2007 DB in which I want to display a split-view form (half form, half datasheet) with a data source of a query. However, there is a chance that the query could be empty. In the event that the query has zero rows, none of the form controls are displayed. Is there any way to make sure all the form controls are displayed...
Does anyone have any experience of using Access 2007 with the prior versions of Access (i.e. mdb files). We have been upgraded, but are still using the mdb format. Some of our code (in particular Docmd.TransferDatabase acImportReport) are now incredibly slow. I tried an initial test and converted our client mdb to accdb and the above T...
I have a foxpro database that we are trying to write to using MS Access 2007 via a VFP ODBC driver (The driver is version 6.x) Are there limitations in doing this? No matter what we try we are not able to write to the foxpro data tables. We are using ODBC It is the MS VFP driver The Foxpro and access DBs are on the same system The OD...
I have the below input mask which take in the date format: 21/10/98 00/00/00;0;_ But i need to be in the below format : 21/10 (without year) This syntax of input mask shown below 00/00;0;_ is not giving the right answer. Please help More clarification: If we right click on the text box of vba form and take the input mask pro...
I am trying to set a report to use a specific printer. I go into design mode, click on the page setup ribbon, click the page setup bottun, go into the page tabt, click the option to choose a specific printer, and then click the printer button to choose the printer I want to use. I save the steps and exit out of the report, but it sti...
Could anyone help me in inserting a input mask formula for date in a access form textbox that shouldnot take year which only take date and month in the below format : DD/MM Not in DD/MM/YY Thanks for help in advance ...
Is it possible to use ASP.net forms authentication to secure access to an application front end built in MS-Access 2007. My current application front end is built in Microsoft Access 2007 with the data residing in SQL Server 2008 Express Edition. I am in the process of porting this application to ASP.net. I intend to use ASP.NET form...
I created a database in ms access2007, created data source in c# from the my MS Access database. I needed fields from two different tables on one form. On the form I coded for the save button: try { this.Validate(); this.entitiesBindingSource.EndEdit(); this.product_DetailsBindingSou...
i have vba textbox where i can take the validation which should only take number and accept UPTO 8 character length how can i put a validation which will take only this? ...
I have a report that tracks how long certain items have been in the database, and does so by tracking it over a series of age ranges (20-44, 45-60, 61-90, 91-180, 180+). I have the following query as the data source of the report: SELECT DISTINCT Source.ItemName, Count(SELECT Source.DateAdded FROM Source WHERE Int(Date()-Source.DateAd...
i have a VBA application which is spitted into two one for front end; and backend while updating how to prevent two users edit it ?? ...
Hi all. I'm having a dead-end situation with one of the clients using my software. Out of about 40 copies of our product sold (Application programmed in .NET 2.0 using VB.NET 2005), about 2 get non-responsive with 1 core of the dual core CPUs stuck at 100% (program uses 1 core only) The most logical guess is an infinite loop causing th...
In Microsoft Access, I have a series of forms that require the user to specify a date range. Right now I do this with Calendar Control 12.0. However, at random times, the control refuses to accept any user input (such as changing the date). Why would the Calendar Control refuse input? Is there any known workaround for this? I'm runn...
Although I have experience with SQL and generating HTML reports with PHP, I'm a relative beginner with Microsoft Access. I'm currently using Microsoft Access 2007 to connect to MSSQL Server 2005. I have a table of Reports that looks something like this: ReportID DateCreated Author ... I'd like to create a form that allows the user t...
I ran into an interesting problem after "updating" an MS Access 2003 database into MS Access 2007 format. I had already implemented many of the new features, and then found out that I needed to also create a 2003 version (for users who would not be upgrading for a month or two)... When I tried to Save As, I got the following error messa...
I designed a query in SQL View using MS Access: select floor(num1) from t1; When I run it, I get "undefined function floor". I get similar errors for Ceil, Mod,Power, Sign, Sqrt, Trunc, and initcap functions. Does the Access database engine's SQL syntax have equivalent functions? ...
In the course of a complex database structure, I need to provide the user with a means of editing data stored in a series of tables. Although all the data types are the same, they don't line up 1:1 in their names. To alleviate this, I created a query that maps the original names (which come from outside reports) to the internally-used ...
Hi all, I have an access report that has two grouping levels, for the most part it works great, but occasionally the detail is too long and the final total prints on a page all by itself. The client would like to move the last detail record to the next page when that happens so the total is not by itself. I know in other reporting to...
I'm trying to open a series of Excel spreadsheets using an instance of Excel created inside of a module in an Access database. I can get the files to open properly; however, the actual call to make Excel start takes quite a while, and to open the files takes even longer. The location of the files doesn't matter (same time to open on a ...