Search results for query: *

The title says it all! I have a very successful Access label report. The client would like the text centred vertically within the label... can it be done? Steve "how much can one body take? ...the concrete shoes, the hungry lake.

The following query SELECT CoursesIndividuals.ID, CoursesIndividuals.FirstName, CoursesIndividuals.LastName, Courses.Date, CoursesIndividuals.CourseName, CoursesIndividuals.Attendee, Courses.Venue, CoursesIndividuals.StartTime FROM CoursesIndividuals, Courses WHERE...

Can somebody talk me through changing IUSER access on XP Pro. Assume I don't know anything about IIS (not far from the truth!). Thanks in advance. Steve

I've got users completing timesheets in Excel and I need to get this data into Access programatically. Could anybody point me towards some resources? The user must use Excel for the timesheets and the format is not changeable so I must use code from within Access. What I'm thinking of is...

Let's say I've got a table called Q1. OK I really do have a table called Q1. What I want to do is show some of the values as they appear in the table (SELECT firstname, lastname FROM Q1 WHERE somecondition). For some of the fields I want to return a flag intstead of the field value if a...

Let's say I've got a table called Q1. OK I really do have a table called Q1. What I want to do is show some of the values as they appear in the table (SELECT firstname, lastname FROM Q1 WHERE somecondition). For some of the fields I want to return a flag intstead of the field value if a...

I've got a Flash movie and I'm passing a variable to it using a QueryString (<param name=movie value="blah.swf?flah="Telephone" ....) It works fine - the text passed in variable 'flah' appears as text in the movie. I want to use the variable flah to format the text as bold, something like...

I have two dropdown lists; Building and room number. They are both poplated from a database. So far so good. When the Building is selected, I want the Room number to relate only to the appropriate building. I can do this easy with two trips to the server. I want to do it with one trip only. So...

Using C# / ASO.Net to create a record in Access. I'm having problems figuring out the syntax to add today's date into a date field in Access. The error message I'm getting is "Data type mismatch in criteria expression. " and the line flagged is "objCmd.ExecuteNonQuery();" Any thoughts...

I'm trying to import a pst file created by someone else. Everytime I go to File -> Import and Export -> Import from another program or file etc The process appears to work and I don't get any error messages. During the import process, I get a personal folder appear in my folder list but this...

I have a small Excel spreadsheet with some buttons with code attached located in Row 3. This was all working fine but recently a problem has occurred. When user prints the sheet the buttons move unpredictably but usually all wind up on top of each other so that only one shows. This happens...

I've done a fair bit of development using Access but a client is asking for SQL Server. It's a pretty simple project from a database point of view. I've two questions. 1 If I develop locally using MSDE, can the database be deployed and used by SQL server. In other words, can I avoid buying SQL...

I'm used to using classic ASP to send email using CDONTS or ASPEmail. Both require a component to be installed on the server. Does the .Net framework have a send email component installed by default or do I need to get a third party component? TIA. Steve "In the Jungle of the Senses

OK, so I'm pretty good with Excel and VBA and I'm kind of OK with Access and VBA. I've been offered some work doing VBA with Word. I don't have the brief yet so I'm not entirely sure what is involved. Should I take the project? In other words, how easy is the transition to Word VBA from Excel...

When a new record is created, I want the value of a field to be the greatest value of the fields in that table (i.e. SELECT Max(order) FROM story; ). However when I enter the SQL into the default value, I get an error message when saving the table (The syntax of the subquery in this expression...