Hi all, apologies for my late reply and inappropriate use of grammars, I'll try my best to avoid that in future. I had read all replies back from start, and I apologize for missing out some contents.
I tried create the linked table manually, it shows an error: "Payment Freq. New" is not a valid name.
I had discussed the issue with my senior, it is not wise to continue further for solution. Because the table we...
colintis
Last Activity: Feb 8 '15, 08:46 AM
Joined: Mar 26 '10
Location: Brisbane, Australia
-
Oh I do feel quite warm even the weather is hot down in Australia.
Yes, because the adp need at least 10 mins to reload every time when open.
It will be with the same interface as the adp has. The adp also contains a form that lists the required tables in the SQL backend. Difference is, the Access database file will not reload everything from the SQL backend on start-up.
Yes there is 'user-group' to limit access,...Leave a comment:
-
Currently I'm told to create an Access database file to improve the performance of an Access Project file, because the database that is setup to be connect from the adp file contains hundreds of tables and other stuffs which is not needed.
What this access database will do is to list the necessary tables, then it will create a link table once the user select it. And to save time from refreshing data at start, these created link tables...Leave a comment:
-
When I run the code, it will populate a ODBC link table into the table list. But when I run the code to this particular table, no error has shown, and the link table is not populate into the table list. The reason I know it involves with the dot within a column name, is I tried creating a pass-through query to open the table, when I execute the query it ask me to enter value to this column. The Access program itself might have reckon the field name...Leave a comment:
-
VBA problem - create link table that has dot in its column name
Hi, I wrote a VBA code to create ODBC link table from SQL server. The code just works fine to most table exist in the SQL server database.
However, one of the table's column name has a dot (e.g. [Payment Freq. New]), which result unable to create link table. Below is the code that creates link tables, is there any solution to include the dot as part of the column name? Thanks.
...Code:DoCmd.TransferDatabase acLink, "ODBC
-
If you are running the query in Access, simply correct Date()-1 into DateDiff("d",1, Date).Leave a comment:
-
Its simply a GROUP BY clause you want.
The problem you have in your initial example is the records are already unique. SQL will not help you to decide taking out which team number (12203 or 13203), the solution to this is to remove the Team_num column. Otherwise this is a continuous nonsense.Code:SELECT (the stuffs) FROM Table_A GROUP BY ORS_ID
Leave a comment:
-
Make ACCDE format database can simply remains necessary functions but disable the design view button.
In Access 2010, click File --> Save & Publish, from the screen it shows, the "Save Database As" should be highlighted, then look for "Make ACCDE" on the right.
Make sure you keep the ACCDB database to yourself for modify / update / upgrade purposes, and split the database into Front end and back...Leave a comment:
-
A runtime version is simply allowing user to open and use access database without any modification abilities. So what you do after downloading the runtime, simply install it on your client's computer, and place the databae into the computer. It's 2 seperate things.Leave a comment:
-
I had made a bit of work around to print the report in a semi-auto way: open report -> open print dialog -> print -> close report.
From the print dialog, I found the database itself changes the setting print quality from "Black and White" to "Colour", this doesn't happen to any...Code:DoCmd.OpenReport stDocName, acViewPreview DoCmd.RunCommand acCmdPrint DoCmd.Close acReport, stDocNameLeave a comment:
-
Problem for report printing's color
I have a simple database to print reports in the company, but the default setting for the printer seems different. The printer's default setting will print all pages in black and white, even the reports don't have any colors as well.
When a print button is clicked, the procedure automatically changed to print in color; because a login is required if the quality is set to color in the company printer. I have no idea why only this database... -
What sort of error you are getting without putting the double quotes aroudn vbSaturday in the query?Leave a comment:
-
I guess the data type in that table field is in text, as Conerlysduck said the data is imported from file.
If that's the case, it will be a bit complicate to convert the date formats. First from string to date, change date format, and convert it back to string. Here's a concept of update query might help
...Code:UPDATE [Table name] SET [date field name] = CStr(Format(Format(CDate([date field name]), "20yyddmm"),
Leave a comment:
-
You can use VBA from the on_click event to print reports one-by-one. A bit annoying method, but it should work along.
...Code:DoCmd.OpenReport "[report name]", acNormal, , "[Parameters]" Reports![report name].Visible = False DoCmd.SelectObject acReport, "[report name]", True DoCmd.PrintOut acPrintAll DoCmd.Close acReport, "[report name]"
Leave a comment:
-
I think TheSmileyCoder must have forgot to remove some extra stuffs.
And I also have the same question that TheSmileyCoder has, if the System_ID is Numerical, then the single quotes are not neccessary.Code:Dim strSQL as string strSQL="Select System_ID FROM tblcheck WHERE System_ID ='" & Me.System_ID & "'" MsgBox strSQL set rs = db.OpenRecordset(strSQL)
Leave a comment:
-
A little correction to your quoting in criteria part
Try again and see if it worksCode:DLookUp ("[Axis Ia dx]", "QryContactComplete", "[IDNumber] = " & Forms!FrmContact![ClientID])Leave a comment:
-
A correction to your current code first, you should place the closing double quote before the & CInt(...). Otherwise you will be seeing this code as part of your result as well. By including the cursor positioning code, it should be like this:
...Code:Private Sub inputDate_AfterUpdate() transNo.Value = "99678*06*" & CInt(Format(inputDate(),'yy')) transNo.SelStart = 10 transNo.SelLength = 0
Leave a comment:
-
Try the following
Code:If Me.DepCity = "HAM" AND Me.DestCity = "PEK" Then Me.DepHandlingAgent = "DSVHAM" End IfLeave a comment:
-
From the control sources, change the criteria part to this.
Code:= DCount("*", "tblSurvey", "[Reply] = 'A' AND SurveyID BETWEEN 1 AND 99")Leave a comment:
-
Take a look on this website as a reference, at least it can show you how to create login stuffs.
The privileges are simply require additional column on user groups you defined. Then it'll be up to you on how the database checks user privilege with the user groups; and how the database should act among these results.Leave a comment:
No activity results to display
Leave a comment: