boblarson

What is the SQL of the query. I'll bet you included the combo inside the SQL and didn't concatenate it in so that it would pass the VALUE and not have to try to evaluate it.

[QUOTE=ITNoobie;1573449]Ok, so basically all 6 tables in my database should have a primary key to foreign key relationship to each other?[/QUOTE] I would say that, NORMALLY you would have tables which are linked together in some way. It is RARE to not be able to link them together. But also, …

[QUOTE=BitBlt;1572467]Use the "On Change" event in your first combo box, update the "filter" property on your second combo box and issue a refresh.[/QUOTE] Actually it should be in the combo's AFTER UPDATE event, not the On Change. On Change will also fire for every keystroke if someone starts typing in …

[QUOTE=TGeorge824;1575147]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 …

[QUOTE=BitBlt;1561848]Yes, it is in MSAccess, it's the first window you see when you open up an MDB file. It shows your list of tables, or forms, or queries, etc. It is referred to as the "Database" window in the documentation.[/QUOTE] It is also referring to the NAVIGATION PANE which is …

[QUOTE=koffimide;1529105]Below is the connection string, <% ' FileName="Connection_ado_conn_string.htm" ' Type="ADO" ' DesigntimeType="ADO" ' HTTP="true" ' Catalog="" ' Schema="" Dim MM_cnxxxx_STRING MM_cnxxxx_STRING = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("./uuuu.mdb") %>[/QUOTE] Check out the Connection String for Access here: [url]http://www.connectionstrings.com/access[/url] Yours doesn't look right.

[QUOTE=crazycat503;1541788]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, …

[QUOTE=isumasama;1537933]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[/QUOTE] I don't believe you can use that directly in a …

You don't need to use the search to find the record in the other table. You would use a SQL Statement and recordset to bring back the appropriate record if there was one: [CODE]'SEARCH FOR THE RECORD IN REMARK TABLE Dim strSQL As String Dim strWHERE As String Dim rs …

[QUOTE=charlybones;1506446]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 …

[QUOTE=Hyo;1513776]I have done this query : Balance:[Medical]![Price]-750[/QUOTE] That isn't a query. That may be PART of a query from the QBE grid but it is definitely not the entire query. If it is then that would explain a lot. Post the SQL of the query (Go to VIEW > SQL …

Copy this function into a standard module (not form, report or class) and name the module something other than the name of the function: [code] Function AdjustProcNum(strTableName As String, strFieldName As String, lngNewNum As Long) Dim strSQL As String Dim rst As DAO.Recordset strSQL = "Select [" & strFieldName & …

I'm assuming Outcome is numeric but it wouldn't have to be but you would change the value for NZ to vbNullString if it is text. [CODE]MyNum1 = ]")[COLOR="red"][B]Nz([/B][/COLOR]DLookup("[Outcome]", "Remark", _ "[IDRemark] = Form![SelectTxt]")[COLOR="red"][B],0)[/B][/COLOR] OutTxt.Value = MyNum1[/CODE]

[QUOTE=erum;1438600]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. …

You can try setting the Search button's DEFAULT property to YES and see if that helps.

Set up the table to be imported to first with the right datatypes and all and then import the data.

You are using the wrong ODBC driver. You should be using one for ACCESS. You don't select the driver based on what you are programming FROM but where you want to connect TO. So you want the Microsoft Access ODBC driver and the connection strings are available here: [URL="http://www.connectionstrings.com/access"]For Access …

It is not a simple task for which you seek. About the only way you will get to do it, short of being an EXPERT Access Programmer and writing a LOT of code is to purchase [URL="http://www.peterssoftware.com/ss.htm"]Shrinker/Stretcher from Peter's Software[/URL] which does do this for you.

Why not just create a frontend in Access?

[QUOTE=amina_latif;1439126]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 …

You don't link SharePoint to an Access database, you link an Access database to SharePoint. Access can display SharePoint data and use it for creating reports, not the other way around. You may want to read this for more information: [url]http://www.databasejournal.com/features/msaccess/article.php/3809741/SharePoint-and-Microsoft-Access---Getting-Motivated.htm[/url]

I answered your question in your other post here: [url]http://www.daniweb.com/forums/thread331196.html[/url]

With tab controls you do not reference any tabs. Just reference a control as if it was on the form itself. If you are referencing a control on a subform within a tab just use the normal syntax for referring to a control on the subform. There is no special …

Control Source of the text box: =DMax("YourDateFieldNameHere", "YourTableNameHere") Replace YourDateFieldNameHere with your actual field which has the dates and YourTableNameHere with the name of the table where the date field resides. And KEEP THE DOUBLE QUOTES.

No, each computer has to have it set up. You can run a batch file to update registry settings ([URL="http://accessjunkie.com/faq_33.aspx"]see here for more[/URL] about the registry settings required).

Yes, you should make an ACCDE file. What is happening right now is that you have compile errors that you need to fix before it can compile to an ACCDE. So, open the VBA window, and go up to DEBUG > COMPILE {yourprojectnamehere} and run the compile. Fix the error …

[QUOTE=adhikariprakash;705537]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[/QUOTE] The short answer is NO, you cannot do this …

To add a form header or footer you can go to VIEW > FORM HEADER/FOOTER or VIEW > PAGE HEADER/FOOTER

[QUOTE=MarcusMaximus;1093091]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 …

[QUOTE=ccmancio;1083909]Compare field Field1 with Ucase(Field1) return 0 ever.. but I have any register with Field1 in mix case. Why Access retur every igual ?[/QUOTE] Access is not case sensitive. If you want to compare strings you need to use binary. Look up the [B]strComp[/B] function.

What is the code that you currently have tried?

You could download and install the 2007 runtime but it would only let you USE the database, not dig into the design views. As mentioned by Gm Xtrm, you would need to have them save it into 2003 format (if they haven't used any of the features of 2007 which …

I would also say that you need to 1. Be using split databases 2. Have each user using a copy of the frontend on their machine. This is the way all multi-user databases should be done anyway, otherwise you're playing Russian Roulette with corruption. What has been showing up have …

So you actually created an import specification which is called "File Import Specification?" Perhaps if you haven't figured it out yet and want to send me your database file and your csv file, I can see what is up. I can PM you my email address if you wish. Let …

I [URL="http://www.utteraccess.com/forums/showflat.php?&Board=48&Number=1634292&page=1&view=collapsed&sb=5&o=all&fpart=1"]think this[/URL] may be what you're looking for.

Tab controls are interesting in that you rarely need to do anything at all with them or reference them. In your case you need to set focus to tab 5 and then refer to the subform on subform. You have to set focus first. I will show you a way …

[QUOTE=simonpaul;759904]i eqally have the same problem and i need urgent help can some body give us a detailed explanation on how to go about it.[/QUOTE] That's not a "quick" thing to be able to do. You need to go learn how to use a programming language if you want to …

[QUOTE=ryan311;755402]because its my assignment and i don't know how to do that :([/QUOTE] Sounds like the assignment may have been misunderstood. But since we don't have the assignment (nor access to the instructor) we can't verify that. If what you are saying is completely true, the way that it was …

[QUOTE=denniskhor;576226]Microsoft Access lo... how is it?? MS Access provided interface and database.. i jz dunno how to convert it to open the designed interface with no need open MS access[/QUOTE] There are some third party tools out that will help you convert an Access app to VB or VB.NET but …

What do you mean by you want the other combo box to have a selected choice? Do you mean that you want one value to be available in the second combo based on the first selection, or SEVERAL possible values in the second combo based on the selection of the …

Check out my sample here: [url]http://downloads.btabdevelopment.com/Samples/dates/ReportAndForm.zip[/url]

Encapsulate the field name in square brackets [Parent UUID] and in the future do not use spaces in field or object names as it simplifies things if you don't.

Not sure what you are actually doing. Are you wanting to export the data from Access into SQL Server 2005 Express? If so, you should be able to use the (on the EXTERNAL DATA Tab) EXPORT > MORE > ODBC DATABASE to send the tables to SQL Server.

Since this is 19 days old, you probably already got an answer elsewhere or figured it out, but here's a sample that might help: [URL="http://downloads.btabdevelopment.com/Samples/combos/CascadingCombosSample.zip"]Cascading Combo Sample[/URL]

I'm using this one (actually the Access 2007 version) [url]http://www.amazon.com/Beginning-Access-2003-VBA-Programmer/dp/0764556592/ref=pd_bbs_sr_2?ie=UTF8&s=books&qid=1214204228&sr=8-2[/url] To teach a beginning VBA class for our Portland Access Users Group. It seems to be pretty good.

Why not just save the union query and use it in another query for your calculations just like using another query.

You would likely need to use subforms, especially if there are any one-to-many relationships.

I personally have always used a DTS package to do this (SQL Server 2000)

You really need to split the database and have each user have a copy of the frontend on their machine. See here for more about that: [url]http://members.shaw.ca/AlbertKallal/Articles/split/index.htm[/url] Also, if you don't want to have to worry about distributing the frontend to each user each time you make a change to …

The answer to your original question as to why the query wasn't working is that you never gave it a WHERE clause to limit what it was doing.