Tag Info

New answers tagged

1

Sorry, this may not be An Answer, but I couldn't add a comment. This is surely a 'solved problem' in that hotel and reservation systems are available commercially 'off the shelf'? Why develop your own? Even if you do decide for good reason that you need to, it might well be worth investigating the data models underlying a few commercial products, if you can ...


1

Cheers for that, why MS Access has to be different to everything else? Mmm. I got to the bottom of it like you said using : G1 = SUM(CASE WHEN GroupNum = 1 THEN 1 ELSE 0 END)*BoardStatus, G2 = SUM(CASE WHEN GroupNum = 2 THEN 1 ELSE 0 END)*BoardStatus, ..... G10 = SUM(CASE WHEN GroupNum = 10 THEN 1 ELSE 0 END)*BoardStatus, G11 = SUM(CASE WHEN GroupNum = 11 ...


0

I solve it by add some extra command in terminal, like this : isql -v mydb and the result : +---------------------------------------+ | Connected! | | | | sql-statement | | help [tablename] | | quit | | ...


0

Try converting to decimal and then to int.


0

To answer the question of whether it's possible to require either one field or another but not both: yes, it's possible, but you'll need to set that up as an Access ANSI-92 SQL check constraint in your table, using the CurrentProject.Connection.Execute DAO method. It's not possible using the Access UI, but once you do it like I describe below, Access will ...


2

Here are some options. CBool—Converts a value to a Boolean data type. CDate—Converts a value to a Date data type. CInt—Converts a value to an Integer data type. CStr—Converts a value to a String data type. CVar—Converts a value to a Variant data type. Syntax CBool(expression) CByte(expression) CCur(expression) CDate(expression) CDbl(expression) ...


1

Perhaps you should store the data in SQL Server as an INT field, instead of a VARCHAR(255) field? If you did that, you wouldn't need to make any conversions in Access. Having said that, if you don't want to make changes to the SQL Server database, you can use VB's CInt(field) in Access queries to convert numbers stored as a string into integers. Be aware ...


0

I don't use Access, but it is likely that it is unable to query extended properties except those under the dbo schema - it must make the assumption that everything is under dbo. I don't really have a solution for you other than not using schemas with your ADP if extended properties are critical.


1

As you have discovered, the Date/Time column type in Access does not support fractional seconds. If you need to preserve the precision (and not round to the nearest second) then you'll need to import the time values as Text and then populate another Long Integer column with the times converted to tenths-of-milliseconds (which I have abbreviated to "tms"): ...


0

It sounds like Customers and Prospects are really subclasses of a superclass, one that might be called "Contacts". If so, you might consider storing them in the same table, with a type field to say whether it's a customer or a prospect. If that oversimplifies your case for some reason, you might want to do some research on "Class Table Inheritance". ...


0

I think of a scenario, where you can have a MasterUser table that will asign ID to both Customer and Prospect, auto incremented PKId can be named as UserID of the table. let Say you create a table MasterUser and stored common details like names etc. that both Customer and Prospect have, now the unique info can be better moved to table Customer and ...



Top 50 recent answers are included