Posts
 
Reputation
Joined
Last Seen
Ranked #2K
Strength to Increase Rep
+5
Strength to Decrease Rep
-1
100% Quality Score
Upvotes Received
7
Posts with Upvotes
7
Upvoting Members
4
Downvotes Received
0
Posts with Downvotes
0
Downvoting Members
0
3 Commented Posts
0 Endorsements
Ranked #1K
~13.7K People Reached
Favorite Forums
Member Avatar for qajaq49

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 …

Member Avatar for wafs
0
507
Member Avatar for ITNoobie

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?

Member Avatar for boblarson
0
188
Member Avatar for chamnab

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 …

Member Avatar for boblarson
0
164
Member Avatar for TGeorge824

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 …

Member Avatar for BitBlt
0
121
Member Avatar for chamnab

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 …

Member Avatar for boblarson
0
137
Member Avatar for koffimide

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 …

Member Avatar for crishjeny
0
318
Member Avatar for crazycat503

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, …

Member Avatar for boblarson
0
105
Member Avatar for isumasama

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

Member Avatar for isumasama
0
177
Member Avatar for isumasama

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 …

Member Avatar for isumasama
0
146
Member Avatar for charlybones

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 …

Member Avatar for boblarson
0
134
Member Avatar for Hyo

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....

Member Avatar for boblarson
0
89
Member Avatar for isumasama

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 …

Member Avatar for isumasama
0
110
Member Avatar for isumasama

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 …

Member Avatar for isumasama
0
572
Member Avatar for erum

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. …

Member Avatar for hchf
0
227
Member Avatar for stephen_UK

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 …

Member Avatar for stephen_UK
0
99
Member Avatar for JoyBh

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 …

Member Avatar for boblarson
0
81
Member Avatar for ellenski

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. …

Member Avatar for boblarson
0
137
Member Avatar for Polongo

How to make the form size automatic setting the size equals to the screen. or Maximize the whole form including the form components.

Member Avatar for boblarson
0
70
Member Avatar for ksaroj

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

Member Avatar for al_aeena
0
78
Member Avatar for amina_latif

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 …

Member Avatar for boblarson
0
68
Member Avatar for blur0224

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 …

Member Avatar for boblarson
0
174
Member Avatar for dreamer_lek91

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 …

Member Avatar for boblarson
0
136
Member Avatar for wewehalim

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 …

Member Avatar for boblarson
0
82
Member Avatar for dreamer_lek91

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=)

Member Avatar for boblarson
0
357
Member Avatar for Datsun90

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 …

Member Avatar for boblarson
0
159
Member Avatar for dreamer_lek91

[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 …

Member Avatar for boblarson
0
181
Member Avatar for elanch

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

Member Avatar for Petre
0
3K
Member Avatar for Yogesh Sharma

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 …

Member Avatar for boblarson
1
147
Member Avatar for MarcusMaximus

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 …

Member Avatar for boblarson
0
163
Member Avatar for ccmancio

Compare field Field1 with Ucase(Field1) return 0 ever.. but I have any register with Field1 in mix case. Why Access retur every igual ?

Member Avatar for boblarson
0
52