- Strength to Increase Rep
- +5
- Strength to Decrease Rep
- -1
- Upvotes Received
- 7
- Posts with Upvotes
- 7
- Upvoting Members
- 4
- Downvotes Received
- 0
- Posts with Downvotes
- 0
- Downvoting Members
- 0
Re:
In MS Access2007, I want to query ([I]q_Notes[/I]) a table ([I]t_Notes[/I]) in which one of the fields ([I]t_Notes.Topic[/I]) is populated from a Combo Box based on a field in another table ([I]t_Topics.Topic[/I]). I will have a table of several hundred records. I want to use the q_Notes query as the … |
|
Re:
I am creating a database in MS Access 2010, I have 6 tables. My question do all 6 tables need to have either a direct relationship (primary key to primary key) or Primary Key to Foreign Key with each other? |
|
Re:
i don't know if it possible or not if i want to like this : Actually, i have one form "Product" In Form, i have two comboboxs , first name cboProduct that have Row Source "CPU;RAM" and second name cboSeries. what i want to do is when i choose a … |
|
Re:
Hi I want to figure out a way to update multiple rows that depend on a couple of variables. I don't really know the syntax in SQL, but I know what I would do in C, so maybe if you could translate this... [CODE] switch (x) case 0: switch(y) case … |
|
Re:
hi i have some question to ask everyone . 1.How make open form in full screen ? 2.Example: I created two completed forms,frmLogin and frmStudent and saved it name "Student".what i want is when i open saved file,i want it only show frmLogin auto(full screen) without choose a form from … |
|
Re:
Help! i cannot access my ms access database i am using to learn web design. I keep getting different error codes depending on the windows webhosting used. The latest i got was : Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Microsoft Access Driver]General error Unable to open … |
|
Re:
Hi, I am trying to come up wit a database design for a small school. it works this way: in AC-Year, there are 3 terms with each term having 2 semesters. New students get registered at the start of each term. A student may take entrance exam. if he fails, … |
|
Re:
hi all, i have created a crosstab query and one of the row heading contains a hyperlink field. my problem is that the field is not working, and on top of that it gives corrupted values too. pls help thanks |
|
Re:
hi all, i need to do a record search in a form where its Record Source is Operation, but instead of searching the Operation, i need to search different table, say Remark.. i supposed the red highlighted code should be the place to set the Remark table, but how to … |
|
Re:
Ok, so after hours and hours of testing and searching online I'm almost convinced that this can't be done, but I'm asking here for help maybe someone can give me any idea as to why this isn't working. I'm doing this query: [CODE]SELECT * FROM( (SELECT t1.PAG5 from table1 t1 … |
|
Re:
I have done this query : Balance:[Medical]![Price]-750 but calculation total didn't show up , and it show up to enter parameter value? help me.... |
|
Re:
Hi all, I have a table where it stores Process. The Process has each processNumber which is unique, & the processNumber indicates the step of a procedure. My problem is, user request to add a Process in between existing processes. In other word the new Process overwrite the existing process … |
|
Re:
hi pls help me on this.. i'm using this code to get data from record: [CODE] MyNum1 = DLookup("[Outcome]", "Remark", _ "[IDRemark] = Form![SelectTxt]") OutTxt.Value = MyNum1 [/CODE] my prob is when the data in [Outcome] is null , access having error to still get the null value from the … |
|
Re:
i m facing problem while conencting with sql server mangemnet studio A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. … |
|
|
Re:
I have a database that has a simple search form where you enter the 'Search Text' and then mouse click the 'Search' button and the results are displayed. Alternatively if the Enter key is pressed twice, first time to enter the text and tab to the 'Search' button, and the … |
Re:
I'm successfully importing a .dbf table into access using the get external data wizard. The issue is the data structure of the imported table. For instance, a filed with num(5) in .dbf will appear as double (without any field length) in the imported table in access. This limits onward use … |
|
Re:
Hi, There is something wrong with my code. I can't seem to access the database anymore not can I add new data information. I am suppose to create a registration form with username and password. Then save it to a database on MS Access. Then login using the login form. … |
|
Re:
How to make the form size automatic setting the size equals to the screen. or Maximize the whole form including the form components. |
|
Re:
Hi, I have made simple database in MS access. I want the front end for that database which can be easy to use the database for 3rd person. Can anyone help me. Saroj |
|
Re:
Hi I am new to VB.NET but for my final year project have started a system for childrens daycare center. I want to create user accounts which I think I should be able to do in acess. How do I link this to VB.NET? is it hard? what will vb.net … |
|
Re:
So I've been reading a lot about Access 2007, but all the books and tutorials don't talk about the stupidly easy questions. I have a SharePoint 2007 running on a server that my team has access to. From what I've read, SharePoint can easily display information and generate reports based … |
|
Re:
Is there any ways to allow the text box in a report to show the lastest date from the database? For example: 24/2/2007 15/4/2009 21/6/2009 14/7/2010 13/10/2010 i want the text box to have 13/10/2010, which is the lastest date out of the 5 date(which I have more in my … |
|
Re:
Hi, i have this main form that has several tab. In the tabs, there are several fields. I want to call/get/set the control/field inside this tab, how to do it? for example, in the main form there is a textbox control called "InvoiceNo", to call this one, i will use … |
|
Re:
I have these few dates in my database and I would like to have the latest date to be shown at my report footer. 03 dec 2001 15 may 2010 08 mar 2007 14 jan 2004 29 sep 2009 can any kind soul plz help me?=) thx alot in advance=) |
|
Re:
Hi all, I have designed an application in MS Access 2007 that will be used in some schools (over 60 schools). Each time I start the application, it shows an alert in the message bar that the VBA macros are disabled, and gives me the option to enable it for … |
|
Re:
[B]how can i disable the save function. The database that I am making now is being shared by many users and i do not want them to mess up with my design and programming stuff that i had done. I have tried making the file into ACCDE format but it … |
|
Re:
hi all! I need to make a form in Ms-Access as EXE file. So that the file can be runned without opening Ms-Access. I know that, it is possible in Vbasic but whether it is possible to do in Ms-Access. Thanks |
|
Re:
Can Somebody plz tell me how to give the form ,a footer & header. I want to write in Heaer-REPORT FIRST But i m not getting how to type the text in Header & Footer, plz reply. Bydefault the user is able to resize the form,I also want that the … |
|
|
Re:
Im having trouble with a running sum for my VAT analysis section of a report. Whats happening is the vat is calculated and rounded appropriately. But the running sum seems to be calculated on the pre rounded figure, is there anyway to rectify this. So i have following figures [I]245.70 … |
Re:
Compare field Field1 with Ucase(Field1) return 0 ever.. but I have any register with Field1 in mix case. Why Access retur every igual ? |