I am developing a vba form for employee database, in that there is a search criteria for userid and employees name with the userid should be displayed in a list box control which comes from a single table I need to populate a list box with value from a table according to a value in a text box which act as a search box (eg: userid) Plea...
Hello all, I have the following SQL statement: Select Choose(1,Orders.Employee, Orders.Customer) as Name1, Choose(2,Orders.Employee, Orders.Customer) as Name2, [Shipped Date] FROM Orders; However, the field "[Shipped Date]" has a space in it and hence why I have put square brackets around it. The problem is, in SQL view, it seems to...
So I have been working with multiple different MS Access apps at work (about 8) for different departments. And it looks as though there are going to stand up a SQL Server at work, which makes sense from a capacity/integrations standpoint. Soooo......I have experience with Access, SQL and VBA, but having never used any of it in a SQL Ser...
I have a legacy Access 2003 database file that must remain in that format to preserve its menus and toolbars. I have recently moved to Access 2007 in my build environment and will be deploying the compiled Access 2003 program with the Access 2007 runtime. In Access 2003, I could script the process of creating an MDE with the Access Devel...
Say I have these tables with field names underneath. DailyLeaveLedger dldEmployeeID dldLeaveDate InvoiceHeader invEmployeeID invWeekEnding InvNumberWeeksCovered So I want a query selects leave days where an invoice covers that leave ie invWeekEnding 02 Oct and InvNumberWeeksCovered = 1 then any leave in the range 26 Sep to 02 Oct is ...
Just wondering: If I have a ppt slides that I want to extract information out of, and I set up the template for all these slides that are used by various people through out the organization, and I know all the "names" to each text box object, can I use some vb to pull that information out of the ppt slides into an access database? I k...
Hi, I'm running Access 2003. I'm using Switch to select date fields based on a boolean criterion: Switch(<criterion>, Date1, 1, Date2) i.e., if "criterion" is true, then return Date1, otherwise return Date2. Date1 and Date2 are Date/Time type columns in a table. The problem is, Switch returns them as Text -- not Date/Time! Is th...
Hey guys. Just wondering if anyone knows of a method to create sparkline graphs on a form in MS Access. The chart builder does not really work very well to create sparkline charts (graphs that small). Just curious, thanks! ...
Please describe the exact steps required to use a compiled Access 2003 mdb with the Access 2007 runtime and retain my custom menus and toolbars so that they look the same as they did with the 2003 runtime. I've tried following the various incomplete instructions around the web, but I either end up with my menus/toolbars on the ribbon's u...
I'm using Access 2003 on a duo-core machine with 4GB of RAM, running Windows XP (Service Pack 3) [5.1.2600] Periodically, I get an error msg "There isn't enough memory to perform this operation. Close unneeded programs and try the operation again." A check of Task Manager indicates that there is plenty of free memory. Closing other op...
A datetime control on a form, bound to a table field, works fine. If I add the picker inside a tab control it raises this error when I load the form: An error occured in a call to the Windows Date and Timer Picker control. Is any workaround for this problem? ...
I have 4 tables, from which i select data with help of joins in select query...I want a serial no.(row number) per record as they are fetched. first fetched record should be 1, next 2 and so on... In oracle the equiavelent in RowNum. ...
My dad built an MS Access Database to do property management. Now he wants to share it with other users over the internet. So I got a hosted SQL Server account at Network Solutions. Now I'm trying to connect the Access 2003 client to a test SQL database using these guidelines from MS: http://office.microsoft.com/en-us/access/HP05274586...
I'm trying to confirm or deny whether you can define a table column in MS Access 2003 as a set. It seems this is implemented in Office 2007 - you can define a column to have a 'multi-select list' in the query/lookup, but this feature appears to be unique to the new access 2007 file format as far as I can determine. Worded another way, ...
So I have a MS Access database at work. Recently I tried to put out another MDE file, that actually took something off a report that was previously there. Now I am getting this error that says, "MS Access cannot create the MDE" with a little show help button....click the show help button and it gives a description about this relating typ...
Is there a way to programmatically check for database object corruption in Access 2003? My development project has gotten complex enough that it's hard to manually check all the objects after a day of programming to see if some small control, form, report, query, or code object has been corrupted somehow. I already have the data split o...
So I have a form that I want the user to use to update multiple tables with. I do not want the form to be bound to the tables, as I would rather do this with VBA (I think, I don't know). So here is a little table example UserTable UserID First Middle Last Division Title EquipTable EquipID AssignedLaptop Model Barcode SoftTable S...
If I try to duplicate an access file (this file is split into mdb and be mdb, and also has mde files), by importing everything into a brand new access application, why won't the table links work? Everytime I click anything it says that the tables cannot be found Probably so simple its not worth asking on here, but ....??? Thanks! ...
Is there a way to use my own number in a table like an auto-number; that is to automatically assign the next available to a new record. We have system ID numbers for each employee that I want to tie into this database. I just want the table to auto assign the next number. Can I do this? Could this be done with a mixture of numeric and a...
I'm creating a form on MS Access 2003 that will send out a html email newsletter to a list of email addresses. How do I put a preview button into my form that will let me preview my email before I send it? I think I have to use an active-x control, but I have no idea where to start. ...